Newbie with Question or Poblem:(

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

John Vinson

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.
Click to expand...

The simplest way to find a username and jump to that user's record
would be to use the Combo Box Wizard (in the toolbox) to put a
navigation combo box on the form. Choose the option "use this combo
box to look up a record".

Post back if the wizard is uncooperative... we know how to whip them
into line! <g>

John W. Vinson[MVP]
 
Top