Record Finder

[DenizBerkel]

I prepared a simple database with a record finder. But it does not work and I can't figure it out why...
Can someone help me with this?
Thank you very much...

[June7]

Did you run Debug/Compile from the VBA editor? There are two Combo0_AfterUpdate events, run Debug/Compile and the one without code should go away.

Have you step debugged (refer to link at bottom of my post for debugging guidelines). The value of listbox is FirstName but the code is looking for ID as criteria.

The comboboxes accomplish nothing. Sure, they tell the listbox to requery but the list doesn't change because its RowSource doesn't have any filter criteria.

[DenizBerkel]

Did you run Debug/Compile from the VBA editor? There are two Combo0_AfterUpdate events, run Debug/Compile and the one without code should go away.

Have you step debugged (refer to link at bottom of my post for debugging guidelines). The value of listbox is FirstName but the code is looking for ID as criteria.

The comboboxes accomplish nothing. Sure, they tell the listbox to requery but the list doesn't change because its RowSource doesn't have any filter criteria.

thanks for your reply. I made the changes that you mentioned. but couldn't quite understand what you meant by RowSource filter criteria. What kind of filter should I put there?

[June7]

If you want the listbox list to change dynamically based on combobox selection then need WHERE clause that references combobox as filter parameter. Like:

... WHERE somefield=[comboboxname] ORDER BY fieldname;

[DenizBerkel]

If you want the listbox list to change dynamically based on combobox selection then need WHERE clause that references combobox as filter parameter. Like:

... WHERE somefield=[comboboxname] ORDER BY fieldname;

OK I will try to do it tomorrow and if I can't I may ask for your help again since this is something I have to do for my job.
Thank you very much, it means a lot to me....