autofill a form

[Guest]

I would like to fill a form after entering the IDnbr of an employee. For
example:

Fields:
IDnbr
Lname
Fname
address
department

On the form I want to enter the IDnbr and have the other fields above filled
in automatically.

I'm using MS Access 97 with Windows XP.

Thanks in advance for your help.

John

 

[Al Campagna]

John,
Actually, you don't want to save that information to a table. Since
you're capturing the IDNbr, you can always "display" all the other
associated information on your form.
I suggest using a combo box (ex. cboIDNbr)
IDnbr LName FName etc...

An unbound calculated text control with a ControlSource of...
= cboIDNbr.Column(1)
would display the LName.
=cboIDNbr.Column(2)
would isplay the FName

etc... for all the fields you need to display.

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."

 

[Guest]

Thanks. I'll give it a try.

John,
Actually, you don't want to save that information to a table. Since
you're capturing the IDNbr, you can always "display" all the other
associated information on your form.
I suggest using a combo box (ex. cboIDNbr)
IDnbr LName FName etc...

An unbound calculated text control with a ControlSource of...
= cboIDNbr.Column(1)
would display the LName.
=cboIDNbr.Column(2)
would isplay the FName

etc... for all the fields you need to display.

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."

 

[Guest]

Al:
I tried your suggestion and it almost works the way I want it to. The first
IDnbr shows up in the combo box. When I open the box and click on the next
IDnbr (0002) I get the information for that record--so far so good. However,
the record number does not change. It stays at record #1 (which is for IDnbr
0001).

Is there a way to make the record number advance to the record whose IDnbr I
display? EX: If I select IDnbr 0003 and that relates to record #6. How can
I get the record number to advance to record 6?

Thanks

John

 

[Al Campagna]

John,
This sounds like an new question. My previous post dealt with displaying
the ancillary information about a IDnbr, after a selection in made.
Now, it sounds as though your combo is not working... which is really
another matter.

Are you expecting, that after selecting an IDnbr from the combo... the
form should go to record that has that IDnbr?
I don't understand how the RecordNo pertains to your original question

Please describe in more detail what you're trying to do with this combo,
and show a few abbreviated combo entries that you might select from.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."