Open form to blank record? (Access 2000)

[BlueChicken]

Is there a way to have a form open to a blank record so that way you can skip the step of either going all the way to the end or hitting the [>*] button?

I still want to be able to access the other files but it would be easier to have it automatically upon opening go to the step that most people will be using the form for - data entry. We have reports set up for viewing and searching information.

 

[boblarson]

In the form's On Load event (not the open event) put:

If Not Me.NewRecord Then
   Docmd.RunCommand acCmdRecordsGoToNew
End If

 

[John Big Booty]

Put the following in the form's OnLoad event;

DoCmd.GoToRecord acDataForm,"YourFormName", acNewRec

 

[BlueChicken]

Sorry for the long wait between replying. I had other priorities to take care of first before the end of the month.

So here is what happened:

In the form's On Load event (not the open event) put:

If Not Me.NewRecord Then
   Docmd.RunCommand acCmdRecordsGoToNew
End If

I tried this but no matter what I do, it always comes back with an error with the If Not Me.NewRecord highlighted.

Put the following in the form's OnLoad event;

Code:
DoCmd.GoToRecord acDataForm,"YourFormName", acNewRec

This doesn't work either.

What am I doing wrong?

 

[boblarson]

What am I doing wrong?

Did you perhaps put it in the OPEN event instead of the LOAD event? You can't put recordset actions in the OPEN event because the recordset hasn't loaded yet.

 

[BlueChicken]

This is what I have:

Private Sub Form_OnLoad()
    If Not Me.NewRecord Then
        DoCmd.RunCommand acCmdRecordsGoToNew
    End If
End Sub

 

[boblarson]

Well, considering there is no OnLoad event - it is clear you typed it in. You should just select the Load event so Access populates the parts around it and then you put the code inside the sub declaration and the end sub.

 

[BlueChicken]

Select the Load event so Access populates the parts around it and then you put the code inside the sub declaration and the end sub.

Where is it. I can not find the option for the "OnLoad" Event.

 

[boblarson]

Where is it. I can not find the option for the "OnLoad" Event.

It isn't OnLoad it is just LOAD and if you open the form in design view, go to the properties dialog and then to the Events tab, you can find it in the list, make sure it says [Event Procedure] and then click the Ellipsis (...) that appears when you click in and it will take you right to it.

 

[Scooterbug]

Go into the form Properties. Click the tab that says "Events". Click on the On Load field, then click the button with the three dots. Select Code Builder.

 

[BlueChicken]

Thank you. I have it working now.

 

[b_c]

works for me


bob's da bomb.

 

[gemma-the-husky]

if you ONLY want to enter new data, just set the forms DATAENTRY property to TRUE

then you cant see existing data - it just enables input of new data

 

[leeza]

Hey Guys,
I am trying the same thing only in Access 97 but there's no option for LOAD in the Ellipses(....) as boblarson mentioned in the thread Can u pls tell me wat I need to do for Access 97
thanx
Leeza

 

[John Big Booty]

With the form in design view click in the small box in the top left hand corner of the form it lies at the intersection of the horizontal and vertical rulers a smaller black square will appear which indicates that you are dealing with form events, know click on the events tabs, in the properties list. the On Load (appears in the VBA window simply as Form_Load() ) event is twelfth down the list (in Access '03 at any rate).

 

[leeza]

I found the on Load option in the properties but it doesn't have the option u r talkin abt tht's why I'm confused

 

[leeza]

I see the On Load potion in the event menu but there's no option as Form_Load()
wat do I do now???

 

[boblarson]

I see the On Load potion in the event menu but there's no option as Form_Load()
wat do I do now???

 

[leeza]

I did the procedure but its giving me an error saying tht either the database is a read-only or its not converted from the older version so the
DoCmd.RunCommand acCmdClearAll method
is not working
any suggestions pls??????]

 

[John Big Booty]

never has it been truer that; A picture paints a thousand words

At Bob ^^^^^^