Open a form in ADD mode

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marco - 05 Jul 2007 13:02 GMT

How can I open a form in ADD mode. My idea is to open a form in order that
users may insert data instead of pressing the button new first.

But that form is already used to show data.

Any idea?

Regards,
Marco

Reply to this Message

Douglas J. Steele - 05 Jul 2007 13:11 GMT

If you set the form's DataEntry property to True, all it will do is allow
adds (i.e.: it won't show any existing data)

If you want the existing data to show as well, try the following on your
form's Load event:

Private Sub Form_Load()
DoCmd.GoToRecord acDataForm, Me.Name, acNewRec
End Sub

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> How can I open a form in ADD mode. My idea is to open a form in order
> that
[quoted text clipped - 6 lines]
> Regards,
> Marco

Reply to this Message

Marco - 23 Jul 2007 18:40 GMT

Hi. Sorry for my late answer.

How can I do this:

I have button A and Button B. If I press button A the form Users will open
to me with the user that I have select. If I press button B, form Users will
open in Add mode.

If I press button A it will open the form in Edit mode in order that I can
change specific user values, if I press B it will allow me to Add a new User.

How?

Regards,
Marco

> If you set the form's DataEntry property to True, all it will do is allow
> adds (i.e.: it won't show any existing data)
[quoted text clipped - 16 lines]
> > Regards,
> > Marco

Reply to this Message