linked object

G

Guest

I am having trouble setting up a form. I would like to be able to pick out a payroll number and in another part of the form have the persons name appear. I have the payroll number as a combo box and the picking works fine but I cannot seem to make it show the name after I have picked. Help Please
 
D

Duane Hookom

Add the persons name as a column in the combo box.You don't have to show it.
Then add a text box in your form with a control source like:
=cboPayrollNumber.Column(1)
Keep in mind that column numbering is zero based so Column(1) references the
second column in the combo box.

--
Duane Hookom
MS Access MVP


Akrt48 said:
I am having trouble setting up a form. I would like to be able to pick
Click to expand...
out a payroll number and in another part of the form have the persons name
appear. I have the payroll number as a combo box and the picking works fine
but I cannot seem to make it show the name after I have picked. Help Please
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box problem in database 3
Using VLookup on user form (VBA) 6
Proper Table Design and Combo Box Help 3
Show Employee Picture on form 1
Database Design/Change Help Requested 2
Textbox Code for Date Format 1
Summing Percent of Totals Calculation - Pro Rata Apportion Problem 0
Combo box problem to Report 3

Top