Newbie Problem/Question

W

Wizard

Hi there,

I have a Form with 3 feilds on. Usersname (Text Input), Location (Lookup
From Another Table), Department (Lookup From Another Table).

I have around 370 records in this table, so clicking the next arrow on the
database record navigation is very tiresome. I was thinking about putting a
table on the botton of the form which has a list of all the above info in
for example,

Simon Green Witham IT Support
Joe Blogs Leeds Accounts

When I click on the line it Automatically take me to the record. Is this the
right way to go about it? How would I even do the above? Any Help or Links
would be greatly Apriciated.

Regards
Wiz
 
J

jahoobob

You can insert a combo box on the form. Use the wizard and select "Fin
a record on my form based on the value I selected in my combo box."
Finish up the wizard selecting the values (I assume it is username).
You can then either use the drop down feature or begin entering th
username in the box to find the record. I would recommend that you us
Last name, First name if you have that in your table. I personally
would never have a table of personnel information without at least Las
Name and First Name. Username is very difficult unless you know the
all. Smith, John is a lot easier to remember than jsmith when you hav
John, James, and Jerry Smith.
Hope this answers your question,
 
Top