An Access 2003 Question

[Marsh]

I am an inexperienced user trying to get a few things accomplished, current
problem is, How can I build a form where I type a unique value (like
Employee ID Number) into a field, press Enter or Tab and populate the
remaining fields for that record.
I would then like to be able to display another record by typing unique
value for another record.
Thanks

 

[Albert D. Kallal]

Try building a "search" combo box.

Open the form in design mode,and add a combo box, when the wizard comes up,
choose the 3rd option to find a record.


The resulting combo box will "populate" all of the fields on the form for
that record (actually, it just moves the form to that record).

If you selected a differnt name (or whatever field you use), then form will
jump to that reocrd...

Give the combo box wizard a try......

 

[Larry Daugherty]

First, design the table on which the form will work.

With your table selected in the Database | Tables window, click the
Autoform Icon (form with a lightning bolt). The wizard will step you
through a few choices to create a form. Try it. If you don't like
what you get, delete it and try different things. Repeat that process
until you find something you can live with to begin. In the event
that the wizard runs to completion without consulting you just take
what it gives you for this exercise.

Before you do anything else you might step through the records you
have in your table. If you don't have any records yet, enter some and
then step back and forth so that you know your form is really looking
at the different records in your table.

To get it to find a record for you:
Place your Form in Design View. On the menu bar click View and then
Form Header and Footer. Also on the View menu choose the Toolbox to
show all of the controls you could place on your form. Make sure that
Wizards are enabled (Wand and stars icon is on).

On your form drag the header down to just over the heighth of a
textbox. Single click the combobox icon on the toolbox. Put your
pointer in the header of your form and draw a fairly large sized
outline of a control. When you release the mouse button the wizard
will come alive. Choose "Find a record...."

In the next dialog box select the primary key of your form and any
other fields you want to show in your combobox.

In the next dialog, allow it to hide the key unless you have a good
reason to show it.

Step on through and give your combobox a name like "Find
WhatEverItIs".

Change from Design View to Form View.

If all went well you now have what you asked. You'll have to tweak
the bits to make it look and feel as you want it.

HTH

 

[John W. Vinson]

I am an inexperienced user trying to get a few things accomplished, current
problem is, How can I build a form where I type a unique value (like
Employee ID Number) into a field, press Enter or Tab and populate the
remaining fields for that record.
I would then like to be able to display another record by typing unique
value for another record.
Thanks

Create a new Form based on your employee table (or use an existing form if you
have one). Make the Toolbox visible (using the View menu option) if it isn't;
select the magic wand icon to be sure it's active. Select the Combo Box icon
and place a combo on the form. Choose the option "Use this combo to find a
record" and base it on a query of the employees table returning all the
employee ID's (or names, if you prefer - you could have one combo box for each
choice).

 

[Marsh]

Great stuff guys

Thank you very much.