469,128 Members | 1,452 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,128 developers. It's quick & easy.

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.

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.
Nov 10 '10 #1
1 1016
TheSmileyCoder
2,321 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
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.