Openquery alters data in record

[Guest]

I have a startup form that displays a listbox of Topics.
When I click on an item in the listbox it opens another form displaying a
listbox of Subtopics for the previous topic clicked on (based on a query).
When I click on a Subtopic from the listbox, it opens another form with
Question and Answer records, relevant to the Subtopic (again based on a
query).

Whenever I click on a subtopic that is one of many subtopics to the main
topic, the last subtopic I click on becomes the 1st record in my table, and
alters the data.

Any advice?

 

[John W. Vinson]

Whenever I click on a subtopic that is one of many subtopics to the main
topic, the last subtopic I click on becomes the 1st record in my table, and
alters the data.

Any advice?

Make sure that the combo box that you're clicking on is UNBOUND -
nothing in its Control Source.

Combo boxes can have two uses: updating table fields, or navigating
using VBA code. The two uses can be incompatible, as in this case!

John W. Vinson [MVP]

 

[Guest]

Wonderful! Thank you!

Make sure that the combo box that you're clicking on is UNBOUND -
nothing in its Control Source.

Combo boxes can have two uses: updating table fields, or navigating
using VBA code. The two uses can be incompatible, as in this case!

John W. Vinson [MVP]