Refining search that use pop down boxes

[damien]

Hi all,

I have a search facility on my database which will find a certain registration no. in a form. The reg. no. is made up of 3 parts. The form is based no a query which separates all reg . no.'s into certain catagories.
I would like to be able to refine my search in the drop down boxes as I input extra info eg. If the reg is made up of 3 parts & I enter the first part in the first drop down box,I want the second drop down box only to include the secondary reg no.s related to the first part and the same with the third part and so refining the search with each extra piece of info.
Sorry if this is confusing,

Thanx in advance 4 help

Damien

 

[LonnieJohnson]

You could use SQL and the wildcard to define the form's record source based on the combo boxes.

Me.RecordSource = "SELECT * FROM TABLENAME " _
& "WHERE REGISTRATIONNUMBER LIKE '*" & COMBOBOXX1 & _
& COMBOBOX2 & COMBOBOX3 & "*'" ljprodev@yahoo.com
ProDev
MS Access Applications