How to add a record in a table and move cursor to first field 2

[hawkeye71]

I am using MS Access 2000.
On a form, I want to place a button, when clicked, it should:
1. add the record to the table
2. Take the focus to the first field in the table (this is not the tab order)
3. the values in the fields do not get cleared once the record is added and the focus is sent to the first field on the form .

Thanks,
Indiana

 

[wokkie]

To save the record use the code behind a save button, DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70,

Then to move to a another control do something like

me.txtName.setFocus

To stop the other fields getting cleared you could set their locked property to true

me.txtField.locked = true

Hope this helps

 

[wokkie]

Cheers hawkeye71, thats my first star...and one of my first responces too!

Hope it works now