SEt focus not working properly

[GPSPOW]

I have a form called "frmModify".

I am using the two statements to show the form and set the focus to a specific text box:

frmModify.show
txtDenAmt1.setfocus

The form shows up okay, but the cursor is set on the first field in the top left of the screen.

What can I do to correct this?

Thanks

GPSPOW

 

[missinglinq]

Have never heard of the .Show Method being used in MS Access. Is this, in fact, an Access problem?

In Access VBA the proper syntax would be something along the lines of

DoCmd.OpenForm "frmModify", acNormal
Forms("frmModify").txtDenAmt1.SetFocus


Linq ;0)>

 

[GPSPOW]

Will this also work in Excel VBA?

 

[missinglinq]

I have no idea! You'd need to post your question in an Excel forum!

 

[GPSPOW]

OK. I did.

Thanks

GPSPOW