G
gvaughn
I have two comboboxes, one shows a list of customers, the other shows a list
of contracts. One customer can have mutliple contracts, but a contract can
only have one customer. I want to limit the contracts in the second combobox
to only the contracts of the customer in the first combobox. I have set the
rowsource of the combobox2 to SELECT ActiveContracts FROM ClientTable WHERE
CLientName = Form.OrderEntryForm.Customer. I belive that it is select all
contracts from the client table where the client name in the table matches
the name in the combox1. The problem is when I run it a parameter value
dialog box comes up and askes for a value for Form.OrderEntryForm.Customer,
WHY? I have already selected a customer. I also set the combobox2 to requery
within the After_Update() for the combobox1. Any other suggestions would be
greatly appreciated.
of contracts. One customer can have mutliple contracts, but a contract can
only have one customer. I want to limit the contracts in the second combobox
to only the contracts of the customer in the first combobox. I have set the
rowsource of the combobox2 to SELECT ActiveContracts FROM ClientTable WHERE
CLientName = Form.OrderEntryForm.Customer. I belive that it is select all
contracts from the client table where the client name in the table matches
the name in the combox1. The problem is when I run it a parameter value
dialog box comes up and askes for a value for Form.OrderEntryForm.Customer,
WHY? I have already selected a customer. I also set the combobox2 to requery
within the After_Update() for the combobox1. Any other suggestions would be
greatly appreciated.