Form - open blank

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

Guest

Working in Access 2003.
When I open a form, it automatically opens with the first record. Is there
anyway of making the form open with a blank record so that users cannot see
this!

Thanks,
Matt
 
Matt,
To open just to a new record...
DoCmd.OpenForm "YourForm"
DoCmd.GoToRecord , , acNewRec
To Open a form so that only New Records can be added and users can't access old records...
DoCmd.OpenForm "YourForm"
Me.DataEntry = True
 
Matt,
Not a big deal, but please don't delete the previous posts on the thread. That way
folks can always see the "flow" of the problem, without having to look back at the
previous posts.

From a button...
My code was meant to be placed behind a button's OnClick Event Procedure. Most apps
have a "main menu" type form with buttons where users have multiple choices as to opening
forms, or opening reports, queries, etc..
If you use macros instead of VBA, you could use the same process as my code to open the
form and goto a new record. That macro would be assigned to the OnClick event of button
also.
** If you have "users" this should be the way the form opens. Users should be kept away
from the Access Database Window.

Via the Form itself...
If you are just opening the form by Dbl-clicking the file from the Access screen...
then in that form's OnLoad event, using VBA...
Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub
or, a macro that would do the same.
 
Back
Top