How can I get my Combo box to work with my subform correctly

[DomingoArguello]

On my main Form I have 1 unbound combo box
[Customer Name] that references a query. The option chosen from the combo box would retrieve the matching record, and would display it on the subform.

Example:

Customer1 Feb-10
Customer1 Sept-10

Here is the issue at hand. If you select the Customer1 Feb-10 from the combo box the record information is displayed on the subform, but when you go and select the second option Customer1 Sept-10 from the combo box the subform still displays the Customer1 Feb-10 and the only way you can view the Customer1 Sept-10 on the subform is to use the Page-Up and Page-Down button on the keyboard from that subform. Is there a way to correct this issue, so that when the option is selected from the combo box it displays on the subform automatically?

Thank you in advance.

[TheSmileyCoder]

Hi and welcome to Bytes.

If you want your combobox to function as a "goto", you need to either have code attached to the combobox's update event, or have the subform setup as linked to the combobox.

Do you have any code (or macro) attached to the combobox at present? How did you create the combobox in the first place?