Struggling

[gvaughn]

I have a drop down list of customers to reference on a order entry form. Each
customer has several different contracts associated with them, which are in
another dropdown list. I would like it whne I choose a customer from the
customer list that in the contract list it shows ONLY the contracts of the
customer NOT all the contracts! Any suggestions from anyone? I would greatly
appreiciate anything!

 

[John J.]

See if this helps: http://www.mvps.org/access/forms/frm0028.htm

John

 

[gvaughn]

Thank you for the suggestion. It almost works now. The problem now is that
when you choose a customer, since each customer has multiple contracts, it
pops up an enter paramter value dialog box. Anything you can think of that I
am not would be benificial. THank you though for the help thus far.

 

[gvaughn]

The SELECT statement is as follows.
i am SELECTing ActiveContract FROM the Client table
my WHERE statement is comparing the Client name to the
Form.OrderEntry.Customer combolist. THe paratmer value is asking form the
Form.OrderEntry.Customer value.

 

[John J.]

Did you try Forms in stead of Form?

Forms.OrderEntryForm.Customer

John

 

[gvaughn]

yeah, thanks that got rid of the parameter value DB but now the combobox is
not populating at all. I don't want to bug you anymore, bbut thanks for all
the help. I got at least this far today

 

[Johannes Blümer]

Did you try Forms in stead of Form?

Forms.OrderEntryForm.Customer

John