I am using MS Access 2000
I have a form (frm_cboclient)that has a combobox on it that I populate by querying a client table for clientID and client name.
What I would like to do then is have a subform that will display all my order infomration from my order table, where the clientID in the order table matches the clientID of the client name selected in the combobox. And if I select a different client from the combo box, have the orders in the subform change to reflect the newly selected clients orders.
I don't think this is too difficult, I just don't know how to pass ID's or values to subforms, or how to pass values between forms.
Any help is greatly appreiated.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!