Form Saving Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having trouble whenever I save a form in the middle of entering information
I have the form linked to a query, which is made from the main table. Whenever I save the information I am entering, and I am not through entering info into the entire form, it saves the information as a new record. So, when I got to finish the form/record, later it saves the rest of the information as another record. So what I end up with is a bunch of partial records that should all be one

Please help - Thank
Madiso
 
Madison Roberts said:
I am having trouble whenever I save a form in the middle of entering information.
I have the form linked to a query, which is made from the main table.
Click to expand...
Whenever I save the information I am entering, and I am not through
entering info into the entire form, it saves the information as a new
record. So, when I got to finish the form/record, later it saves the rest
of the information as another record. So what I end up with is a bunch of
partial records that should all be one.

How are you saving the record? Does the query contain any other tables
besides the one you are intending to write to?
 
Hey - thanks for replying

I actually decided to link the form to the main table, and thought that that would solve the problem. However, I am still having the problem.

To answer your question
I am saving the record by simply closing the form and then Access automatically saves the info into the table. But, on my form, I have to tab through different subforms to enter all the data - that might help you to know

Thanks again

madison
 
Madison Roberts said:
Hey - thanks for replying.

I actually decided to link the form to the main table, and thought that
Click to expand...
that would solve the problem. However, I am still having the problem.
To answer your question:
I am saving the record by simply closing the form and then Access
Click to expand...
automatically saves the info into the table. But, on my form, I have to
tab through different subforms to enter all the data - that might help you
to know.

Any reason you are using subforms if all of the data is going to a single
table? Normally subforms are used to enter the "many" records in a table
with a one-to-many relationship to the table the main form is bound to.
 
Back
Top