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

Value returned from look-up

P: 56
I have a table that has a field where I use the look-up from another table's field. When I put this into a form or report. It returns an integer in the field rather that the value (text) from the look-up drop down. How can fix this?
May 28 '09 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 407
Make a select query that joins your main table and your lookup table and use this as the underlying data for your forms or reports. Then you can put the data from the main table and the corresponding text from the lookup table on the form/report easily.

May 29 '09 #2

Expert Mod 15k+
P: 31,712
As Jim says, if you want the value from the linked table then you will need to include it in your record source. This is done by creating a query with the two tables linked.
May 29 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.