Beginning Point

[Russ]

I have a form where I enter in some information. When I open the form, I
would like the form to open up to either the last record or a new one. Right
now, the form opens up to the very first record. Thanks...

 

[Joan Wild]

Open the form and set the Data Entry property to Yes.

 

[Guest]

Create a macro called GoToLast. In the first line in the action column,
select GoToRecord. Below, select:
Object Type = Form
Object Name = the name of your form
Record = Last (or new).

Save the macro.

In the form's OnLoad event, select the name of the macro you just created.

Barry

 

[Russ]

Where is the Data Entry property located?

Open the form and set the Data Entry property to Yes.

 

[Russ]

I created the macro, but where is the OnLoad event in the forms?

 

[Russ]

I got it Barry. Thank you. it works the way I want it to.