Populating tables with forms

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

Guest

Is there a way to set up a form that will not automatically send data to the
table until I instructed it to(possibly by a add record button)?

Any help would be appreicated.
 
Neal said:
Is there a way to set up a form that will not automatically send data
to the table until I instructed it to(possibly by a add record
button)?

Any help would be appreicated.
Click to expand...

Yes, it's called an unbound form. An unbound form has no ReccordSource and the
controls it contains have no ControlSource. You make entries in the controls
and then (upon pressing a button) you execute an append query that uses the
values on the form as the values list.

INSERT INTO TableName
VALUES(Forms!FormName!Control1, Forms!FormName!Control2, etc..)

The downside is that you lose a lot of the events and control that bound forms
provide and thus have to code all of that yourself. For example an unbound form
control has no DataType so there is nothing to prevent a user from entering
alpha characters into a field that should only contain numbers or dates. There
is not even an easy way to control the length of what they enter.

Over all a LOT of extra work just to have an explicit save button.
 
Back
Top