In a Query seeing values of Bound Column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a Query, the returning value of a field is the number in a bound value,
instead of the value of the second column, which is what I entered in the
ACCESS form. How can I solve this? Please help!
 
You mean you're using a Lookup Field? Then it's working as it's supposed to.
Look at http://www.mvps.org/access/lookupfields.htm to see why most of us
don't like them.

You'll have to join the two tables together in your query, and pickup the
field you want from the second table.
 
You must log in or register to reply here.

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

Parameter Value error in a Subform 0
Access 2003: populate combobox with CSV values from table column 1
SetValue for fields on a bound subform 1
Bound & Unbound Controls 1
Get displayed text from ListBox? 2
Access MS Access Listbox not saving to bound field 0
assign a value to bound textbox 1
Testing if record in form is available for editing 1

Back
Top