What I want to do is have a combo box show only the attorneys that match the Customer/Acct# from previous orders. What is the best way to do this? The user will start the order by entering an account number, then when he goes to the Attorney combo box it should only display the attorneys that work for that account. The attorney field is in the Orders table that is related to the customers table...help...
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Having a combo box that displays data that matches Acct Number
- Thread starter WallT
- Start date
FirstAndGoal4
Programmer
Upon some event (i.e. form_current, acctnumber_afterupdate), set the RowSource property of the combobox to a query selecting the correct attorneys and then requery the combobox.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question