Drop-down box not changing associated records

[Madmartigan]

I have a form based on a query. It shows receivable by customer and age buckets. I created the form and want to make customer name a drop down box that will have the other fields update based on which customer is selected.



When I first created the form and changed the customer name field to a drop-down, only the first customer in my query shows up as an option. However, if you use the record selection buttons at the bottom left, you can scroll through each customer in order and all fields populate properly.

So I then tried to base the "Row Source" of my drop-down box on the customer name (Group By Query) and that adds all the customers to my drop-down list like I want but it won't let me actually select any of them (the computer makes the unhappy ding noise).

I have to be close - what am I missing here?

[Madmartigan]

I tried creating a new combo box using the wizard and that gets all the customer names in there and I can select them, but the other fields do not change when the combo box selection is made.

[Madmartigan]

Well I figured it out. I put a macro on AfterUpdate:

SearchForRecord:

="[Customer] = " & "'" & [Screen].[ActiveControl] & "'"

Had no clue but I found another database that did something similar and that was the only difference I could find.