Right I have another Access problem.
I have 2 forms, Customer + Service1.
Customer holds
Customer ID = autonumber
Forename
Surname
Company Name
Company reference
Address
Address 2
Service = list box with 3 items
Now I have added some VB to a button, which says if service = "soandso" then docmd.openform "soandso"
I want it so that when it opens the form from Customer it will only show the information that is listed under Customer. So if service holds carparts, and I want to add a part for one customer, when I click the button, it will automatically log it under this customerID number and when I view it its only listed as a part for this customer.
How is this to be done?
Thanks
Will


LinkBack URL
About LinkBacks
Reply With Quote