input box

S

Sibes

I need your help again

I have a form for editing employees. And i have 2 problems with it.

1. I want the user to enter an employees last name and have the form open
to that employee. I would like to use an input box, but entering the name
into a text box is always an option too. Any suggestions on how to accomplish
this.

2. I would like command buttons of the alaphabet, when the user clicks on
the letter the form will go to the records that start with that letter.

Thank you in advance. This site has got me out of a few jams..
 
F

fredg

I need your help again

I have a form for editing employees. And i have 2 problems with it.

1. I want the user to enter an employees last name and have the form open
to that employee. I would like to use an input box, but entering the name
into a text box is always an option too. Any suggestions on how to accomplish
this.

2. I would like command buttons of the alaphabet, when the user clicks on
the letter the form will go to the records that start with that letter.

Thank you in advance. This site has got me out of a few jams..
Click to expand...

Add an unbound combo box to your form header.
If you use the Combo Wizard to create the control, select the third
option on the first page of instructions "Find a record ...."

Make sure you include the EmployeeID as well as Employee Last and
First names (There may be more than one John Smith.).

Set the Combo Limit to List to Yes.
Set the Combo AutoExpand to Yes.

Then simply start typing the name and the combo box will let you
select the name you want.
 
A

Albert D.Kallal

Why not just place a combo box at the top (use the wizard...as it will
create a "find a record" for you).
 
Top