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.
January 22, 2005 11:39 PM
February 2, 2005 3:44 PM