How to return current customer

[Ann]

I have a form with a combo box that displays a list of billing dates and when
I choose a billing date, I want it to only show me the possible bill dates
for that one customer and currently, it is showing me all billing dates for
all customers.

Is there a statement to use in the control source (or somewhere) that is on
the order of "= current xxxxx" that will do this?

Thanks.

 

[KARL DEWEY]

Yes, open the form in design view and see what the combo Row Source is. If
it is a SQL statement then post along with the name of your form and combo
box. If it is a query then post the query SQL with the name of your form and
combo box.

 

[Ann]

Hi Karl -

There actually isn't a "Row Source"...I see a "Control Source" and there is
nothing listed for it. It's just blank.

The name of my form is "BillingSubform" and my combo box is "Combo 460".

Thanks for your help.

 

[John W. Vinson]

Hi Karl -

There actually isn't a "Row Source"...I see a "Control Source" and there is
nothing listed for it. It's just blank.

The name of my form is "BillingSubform" and my combo box is "Combo 460".

Open BillingSubform in design view.
View its Properties.
Select Combo460.
Select the Data tab.
One of the properties (on my version it's on the third row) is Row Source
Type. What's in that property?
Another - the next - is Row Source. What does that contain?