472,146 Members | 1,383 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,146 software developers and data experts.

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

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.


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.
Nov 10 '10 #1
1 1058
2,322 Expert Mod 2GB
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?
Nov 11 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by martim07 | last post: by
1 post views Thread by Daniel | last post: by
2 posts views Thread by biganthony via AccessMonster.com | last post: by
reply views Thread by Saiars | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.