"Add a Record" Command Button

wislndixie

New Member
Joined
Feb 13, 2004
Messages
23
I've got a command button on my form to enable me to "add a new record". As it's set up now, when I click the button, it brings up a blank new form, which is what I want, BUT, I need the button to bring up the new form AND default to a control named "SS#". The SS# is the first field in my form. Any easy suggestions? I'm a novice, novice.
thanks,
Mike
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

pritcham

Board Regular
Joined
Oct 26, 2005
Messages
128
Hi Mike

Take a look in the help file for how to set the Tab Order for controls on a form and use that to make the relevant textbox the first in the list (i.e. Tab Order = 1).

Hope that helps
Martin
 

Watch MrExcel Video

Forum statistics

Threads
1,118,029
Messages
5,569,747
Members
412,289
Latest member
Kingchaos64
Top