I have been working on building an Access database file for our business for about a week now. I keep running into the same problem no matter how I try to start the datbase. Here is the scenario:
We offer basically 4 services to our customers. A customer may buy one service, or all 4 or multiple repeats of the same sevice. When a new customer calls, I want to open a form and take some generic information (i.e. name, address, phone number etc.) then at the bottom of the form I would like 4 buttons (1 for each type of service we have). I have done this, and created 4 forms that are based on each service, and the buttons each work properly (using macros) to open the proper form. So Customer1 calls, I take their info, and they want ServiceA so I click the ServiceA button. The ServiceA form opens, and here is my problem. On the ServiceA form, I have fields for customer name, address, phone number etc. (all of these fields are based on the Customers table so I am not duplicating data in two tables) and I would expect that these fields would be complete based on the relationship between the two tables. (Customer1 is assigned an autonumber when the record is saved and this autonumber is linked to the Customer number on the ServiceA form.) Unfortunately, when I open the form, all the information is blank. If I type in the Customer number (and I make that number the same as the autonumber assigned in the Customer table) then close the ServiceA form, then open the ServiceA form again, then like magic, the Name, address, and phone number etc. is there. Is there anyway to make this information automatically fill in to the form I select when I click it's respective button? I have searched through many forums, and sites trying to find a solution, I even bought Access for Dummies, but I can not figure out where I am going wrong.
