Go To Record

[Carly]

I have setup the following in an access database (attached):

When you open the database a form opens automatically with a button on it, Click the button and it runs a module which makes it go to the first record of the table.

I'm OK so far!!!

What I would like to do next is force the focus to be on the last column of the first record (Stock New Column). Is there anyway of doing this?

I have tried using [Stock New].Setfocus and this doesn't work

Please help

Regards
Carly

 

[ghudson]

I am using Access 97 so I could not open your attachment.

Try this...

'go to the first record of the record set
DoCmd.RunCommand acCmdRecordsGoToFirst
'set the focus to the Stock New text box
Me.[YourControlName].SetFocus

HTH