Windows XP 
Access 2007
all, using access 2003. I know what I am trying to accomplish but don't know how to explain it. I will try. How can I add controls to a subform to appear like a table. My database has two tables which creates a one to many relationship. One invoice can have many tracking records. I already have a subform on a the mainform show the tracking numbers for every invoice. Now I need another subform for the accounting part which consist of 3 combo boxes. I am not sure it should be a subform. I need the combo boxes to appear like a record to the invoice. Ex. When the invoice is selected on the main form; the corresponding tracking number appear. Then I would like another subform that contains 3 combo boxes and an unbound field to allow the users to enter an amount. Once they create what I would call one record; if needed I would like the form to automatically create another record like they are filling in a table. I don't want to create 10 fields and they only need 5 but I don't want to limit them if they need 15 fields. After the records are complete; I want to total the amount fields whether they are 1 or 20 records. I know I came accross something like this before but I don't know how to start. I've attached a word doc to get an idea of what Im talking about. Any help would be greatly appreciated. Thanks
Reply With Quote
