Forms

[Guest]

How do I make sure my form is clear of data everytime I use the form and how
do I make sure all the data entered into the form is uploaded to my master
table?

 

[chriske911]

How do I make sure my form is clear of data everytime I use the form and how

do I make sure all the data entered into the form is uploaded to my master
table?

you mean open with a blank form to allow users to input data?

docmd.OpenForm "frmWhateverName",acNormal ,,,acFormAdd ,acDialog

grtz

 

[Guest]

Sorry, yes you are correct. When I open the form, I see the data still filled
in the form.

 

[GAVO-UK]

Is your form bound to a table? If yes then place a button on the form
with the following code (button options > events > on click)

DoCmd.GoToRecord , , acNewRec

If your form is bound, then after entering the new record all you need
to do is close the form and your data will be saved into the table the
form is bound to, or you can also place a button on the form with the
following code to save the record.

DoCmd.RunCommand (acCmdSaveRecord)

Use the access wizard to create custom buttons and other controls
automatically, just grab the button and place it on the form in the
design view, if it does not work then you need to turn on the wizard by
select the "Control Wizard" option on the tool box menu bar (The little
magic wand)

GAVO

 

[harish]

Is your form bound to a table? If yes then place a button on the form
with the following code (button options > events > on click)

DoCmd.GoToRecord , , acNewRec

If your form is bound, then after entering the new record all you need
to do is close the form and your data will be saved into the table the
form is bound to, or you can also place a button on the form with the
following code to save the record.

DoCmd.RunCommand (acCmdSaveRecord)

Use the access wizard to create custom buttons and other controls
automatically, just grab the button and place it on the form in the
design view, if it does not work then you need to turn on the wizard by
select the "Control Wizard" option on the tool box menu bar (The little
magic wand)

GAVO

 

[Guest]

If the form is not bound to a table, how would I procedd to do so? Thank you.