searchable fields

[newbieone]

I have been out of the access programming for about five years. Now I am having to use those skills again and they aren't comeing back as fast as I like.

How can you make a field on a form searchable. I thought there was a way you could tell the field it was a list box and have it allow you to enter data then search for it.

 

[stix4t2]

Do you mean you want to use one textbox to add search criteria to find in another?

 

[newbieone]

actually I just want an easy way to search a form if that is possible in access 2003. I think I remember it being much easier in Access 2000

 

[stix4t2]

Search for what? Search all the controls? Select records by the search?

 

[newbieone]

sorry I want to have a combo box that when the user starts to type in a last name it brings up the record for that person or allows them to choose which person from the list.

 

[PHV]

Why not simply follow the combo wizard ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[newbieone]

I did and the field I want searchable is in fact working but it doesn't bring up the whole record only the last name. what did I do wrong?

 

[stix4t2]

ColumnCount property and columnwidth properties determine which columns are shown and which are hidden. If you set a column width to 0 it is hidden.

That said you can use the combobox_changed event to build a filter for the form to limit the records shown

Private sub combobox_Changed() 
    me.filteron
    me.filter = "[LastName] Like '" & combobox & '*"
end sub

keep in mind you have to adapt this code to your variables.

 

[PHV]

I talked about an unbound combo created with the 3rd option of the wizard.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886