Another problem with queries

[Viggen66]

I have seem to have encounter another problem, with my database.

I have built a combobox to search for managers, and based on those managers, records will be displayed on a subform.

The main problem is that as I change from one manager to another, Access brakes the table by copying, the first record to another I have chosen, of course the combobox is a query.

Is there a way to fix this?

[pbaldy]

It sounds like your "search" combo is bound to a table. It probably shouldn't be.

[Viggen66]

Hi pbaldy

Once again you have solved my problem, and I want to thank you for your assistance, you are truly worthy of an MVP designation, continue with your work.

I have transformed the combobox to an unbound by eliminating in the Data proprieties the Control Source, and hence solved the problem.

[pbaldy]

Thank you, and you're welcome!