Newbie Question - Searching a database

[jkchild]

Hi

I have a form where users input data. I would like to add a box whereby a user can search for a particular company.

If possible I would like the user to be able to put the first three letters of a company and another box appears with a list of companies whose name starts with the said three letters, then the user can select the correct company as required.

Is this possible? Can someone advise me please?
Thanks
J

 

[Andrew Fergus]

Hi

Is the selection of the company name using the method you described purely a replacement for manually entering the company name when entering data? In particular, you want to capture the name in the underlying table? If so, then how about creating a combo box in place of your existing text box - this will display a list of all records and as the user starts typing it jumps to the record that matches what has been input so far.

I trust this helps - hopefully I haven't misunderstood your question!

Andrew

 

[jkchild]

Hi Andrew

The method is not purely a replacement for manually adding data. Effectively the search box is to recall data already input.

Thanks
J

 

[jkchild]

Ok Plan - B - Searching a database

Hi

I'm onto plan B as plan A is not getting me anywhere.

I have a form which is where users create new records in a database. (Customer records). On the form I have added a combo box and selected Properties, All. In the Row source line I have added Table/Query, in the Row Source line I have made it point to the customer name in the database.

This seems to work OK, but when I add a new record the combo box list does not automatically add in the new record.

Is there a way to fix this?
Thanks
J

 

[Andrew Fergus]

Hi

Add the following code to the 'got focus' event of the combo box :

Private Sub MyCombo_GotFocus()
    DoCmd.Requery ("MyCombo")
End Sub

Use the actual name of your combo box in place of "MyCombo". Just ask if you aren't sure how to use the code.

HTH, Andrew

 

[jkchild]

Hi Andrew

That has worked a treat.

Many thanks
J