Hi all,
Im going crazy!
I have a sub form showing query results on my main form where the user can directly select a field which is then displayed in a text box back on the main form.
I also have a combo box, which is completely unrelated to either the text box OR the combo box. this is populated with a simple Value List.
Yet, when i select a value in the combobox list, the subform refreshes, and "defaults" the users selection to record 1.
I have stared at the code for the combobox, form and detail in VBA to make sure that I haven't inadvertently linked things but they are completely seperate.
Does anyone have any ideas what could be happening? I have another combo box that does similar job to the first, but DOESNT affect the subform.
Many thanks!!!
Chris
Im going crazy!
I have a sub form showing query results on my main form where the user can directly select a field which is then displayed in a text box back on the main form.
I also have a combo box, which is completely unrelated to either the text box OR the combo box. this is populated with a simple Value List.
Yet, when i select a value in the combobox list, the subform refreshes, and "defaults" the users selection to record 1.
I have stared at the code for the combobox, form and detail in VBA to make sure that I haven't inadvertently linked things but they are completely seperate.
Does anyone have any ideas what could be happening? I have another combo box that does similar job to the first, but DOESNT affect the subform.
Many thanks!!!
Chris
Last edited: