Table in Form

[CodeCracker0291]

Basically, what I want is to put a table in a form and have the table become blank when I go to enter a new record. My only problem is that When I last tried it, I could enter everything and then go to a new record but when I went back it had deleted everything off the table.

 

[jwindon]

What are you using as a record source for your table?

What is the record source for the "table"? Is this a datasheet view subform?

Need more information to help.

 

[CodeCracker0291]

Um I'm not sure..sorry.. Um ok...I have 3 tables. One named Customer Info. (it has stuff like Name, Address, Phone, etc.) Inventory (which has list of model numbers, prices and quantity on hand) then I have another table named Subform (which I use for the subform- it has Model Number and Quantity. The Model Number is a combo box that has all the inventory in it. I don't know what to link and what one-to-many relationship I need to do. I don't even know exactly what that is. Thanks for your help.