CodeCracker0291
01-20-2002, 08:59 AM
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
01-20-2002, 09:30 AM
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
01-20-2002, 10:10 AM
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.