How to filter a field based on the other fields in the form?

[jaishu]

Hi,

I have a form where user enters an ID in a text box, the ID is actually 10 digits, but even if the user enters 5-6 digits , my code is supposed to pick tht and based on tthis it should populate a combobox with all relative products( product IDs). how do i do this ?

Form.RecordSource = "Select * from table1"
Form.Filter = "ID='" & User entered id& "'"
Form.FilterOn = True

What is that i m supposed to specify (equivalent to the Sql syntax LIKE)???
in the second line how do i specify it?

Thanks so much in advance!!

[ADezii]

Hi,

I have a form where user enters an ID in a text box, the ID is actually 10 digits, but even if the user enters 5-6 digits , my code is supposed to pick tht and based on tthis it should populate a combobox with all relative products( product IDs). how do i do this ?

Form.RecordSource = "Select * from table1"
Form.Filter = "ID='" & User entered id& "'"
Form.FilterOn = True

What is that i m supposed to specify (equivalent to the Sql syntax LIKE)???
in the second line how do i specify it?

Thanks so much in advance!!

[CODE=vb]Me.Filter = "[ID] Like '" & Me![txtUserID] & "*'"[/CODE]

[jaishu]

Thank you so much, Its pretty much the same, i was wondering if i can really use it. Anyways Thanks very much!

[ADezii]

Thank you so much, Its pretty much the same, i was wondering if i can really use it. Anyways Thanks very much!

You are quite welcome. The crazy thing about this business is that pretty much the same usually does not get the job done (LOL).