Saving data from forms

  • Thread starter Thread starter Fie
  • Start date Start date
F

Fie

Hey...


None of the data iv entered into my form seems to save... it looks like
it saves 1 record and as soon as you enter another is over writes the
previous record..!!! How do i over come this problem? Iv tried adding a
save button to my form but that dont work either.


HELP

fie
 
It sounds like you have bound your form to your table. Try making a new form
using the form wizard. Make sure a table or query is chosen when involking
the wizard. That will automatically bind your form to the underlying data.
Then you can check any possible differences between your form and the
wizard's form using the property sheet in Design View and make the
corrections to your form.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
The only differences that i can spot is that in some of the fields i
have calculations in hte control source fields.. is there anywhere else
i could put these calcualtions.. or how can i un-bind my form to my
table???
 
Fie said:
Hey...


None of the data iv entered into my form seems to save... it looks like
it saves 1 record and as soon as you enter another is over writes the
previous record..!!! How do i over come this problem? Iv tried adding a
save button to my form but that dont work either.
Click to expand...

Does your form have a recordsource?

Keith.
www.keithwilby.com
 
Fie said:
whats that????
Click to expand...
Your form needs a record source (a table or a query on a table) else your
data will not be stored. When you open your form in design view do your
text boxes report "unbound"? If so then you need to bind your form to a
record source.

Keith.
www.keithwilby.com
 
Fie said:
The only differences that i can spot is that in some of the fields i
have calculations in hte control source fields.. is there anywhere else
i could put these calcualtions.. or how can i un-bind my form to my
table???
Click to expand...

You almost never need to save the results of a calculation to the table. It
is against the normalization rules for the design of a relational database.
For the most part, you can recalculate the results faster than you can
access the data on disk anyway. Using unbound forms requires writing code to
save every control to a field in a table.

Just don't worry about the calculations. Instead, save every element of the
calculation to the table and recalculate when required.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top