Unanswered: on opening a form? and store data automatically
when i open the form can i have the table where the database info is kept open up underneath it on the same page. and how do i make sure that all the data once entered into a field automatically goes into the table
My question would be why do you need the table of data in a spreadsheet on the same form you are trying to use to enter the data?
If you just base your form off of the table and then edit your form in design view and add a spreadsheet with the record source being the table that should accomplish what you are trying to do because they wont even be connected except that the form is based on the table you are viewing in the bottom of the form.