By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,899 Members | 1,066 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,899 IT Pros & Developers. It's quick & easy.

Another Dumb question about adding record via form

P: n/a
This may be a dumb questions please forgive

I have a form that shows a list box that links to a table with 7
employee names
The form does not show employee key.
When adding record to master table I only need to add employee key.
So if I've entered a record for John Doe who has an employee key of 4.
How do I insert the number 4 into my master table?
The user selected John Doe in the box.

Does my question make since?

Thanks
Steve
Oct 22 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Oct 22, 12:48*pm, Steve <dafella...@yahoo.comwrote:
This may be a dumb questions please forgive

I have a form that shows a list box that links to a table with 7
employee names
The form does not show employee key.
When adding record to master table I only need to add employee key.
So if I've entered a record for John Doe who has an employee key of 4.
How do I insert the number 4 into my master table?
The user selected John Doe in the box.

Does my question make since?

Thanks
Steve
your listbox should have a recordSource that includes both the
employee key and name
and it should show 2 columns, with widths of 0";1"

this will show the name but will store the key in the field
Oct 22 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.