Table 4-4 lists the settings for these controls.
Table 4-4. Command Button Settings
Item/Property Value
CommandButton ??”
Name: cmdPrevious
Caption: <<<
CommandButton ??”
Name: cmdNext
Caption: >>>
CommandButton ??”
Name: cmdSave
Caption: Save
CommandButton ??”
Name: cmdCancel
Caption: Cancel
CHAPTER 4 n USERFORMS 155
The UserForm should now look something like Figure 4-23 in Design view.
Figure 4-23. Personal information data entry page
The Address Information Page
Add the controls listed in Table 4-5 to Page2 of theMultiPage control. These will correspond to
the address information column headings on the EmpData worksheet.
Table 4-5. Address Tab Control Settings
Item/Property Value
Label ??”
Name: lblEmpName
Caption: lblEmpName
Label ??”
Caption: Street Address
TextBox ??”
Name: txtStreetAddr
Label ??”
Caption: Street Address 2
TextBox ??”
Name: txtStreetAddr2
Label ??”
Caption: City
CHAPTER 4 n USERFORMS 156
Item/Property Value
TextBox ??”
Name: txtCity
Label ??”
Caption: State
TextBox ??”
Name: txtState
Label ??”
Caption: ZIP Code
TextBox ??”
Name: txtZip
Label ??”
Caption: Phone Number
TextBox ??”
Name: txtPhone
Label ??”
Caption: Cell Phone
TextBox ??”
Name: txtCell
Page2 in Design view should look similar to Figure 4-24.
Figure 4-24. Address information data entry on Page2
CHAPTER 4 n USERFORMS 157
The Equipment Information Page
Add the controls listed in Table 4-6 to Page3 of the MultiPage control. These will correspond to
the equipment information column headings on the EmpData worksheet.
Pages:
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171