Struggling

  • Thread starter Thread starter gvaughn
  • Start date Start date
G

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!
 
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.
 
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.
 
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
 
Back
Top