Setting focus after adding record

[MikeG]

After clicking on my ADD RECORD command button on my form, what do I need to do to set the focus to a particular field once the form "refreshes"? The first field in the form is a date field, defaulted to the current date and I'd like to skip that field and jump to the next. Unfortunately the cursor is not displayed in any of the fields after ADD RECORD is used. I'm sorry, I'm VBA challenged!

 

[casey]

try at the end of your commandbutton code

Me.YourFieldName.Setfocus

HTH

 

[MikeG]

Thanks Casey! I was using Me!Fieldname.SetFocus.... Duhhhh!