Button control direction

[Nick]

I have a form with an "Add" button, after hitting the button the form clears
and I have to point to cell to start my add. How do I set up the form to go
the designated cell after the add button is hit.

 

[Ron2005]

If you are talking about ACCESS and by cell you mean a field:

me.firstfieldname.setfocus

You might want to review the Tab order on the form.

 

[Lynn Trapp]

First of all, understand that Access doesn't have cells. Second, what you
need to do is add code to your "Add" button to set the focus to the control
you need it at. Something like this:

Me.YourControl.SetFocus

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Nick]

Sorry about the "cell" statment, I could think of what to call it.
Thank you,