Re: Qry not pulling bound column problem


"AJ" <AJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FA8616B0-B2A7-4FD5-A328-957BE2FEED3A@xxxxxxxxxxxxxxxx
I have a qry where I pull records from a table. When I run this qry all is
fine, I get the bound column (1) returned which is the text I want not
the
primary key which is in column(0).
I do the same for another table... all is fine. Note these 2 were created
using the design view of Query... I'm not a programmer... just a chemist
trying to build a database.


Hi fellow chemist!

You're another victim of Microsoft's misfeature, the Lookup Wizard. Your
table and query APPEAR to contain the text... but they don't. The combo box
conceals the actual content of the table from view.

If you want to see the text, use a query joining your main table to the
lookup table and select the text from the lookup table (and, if you want to
see both the ID and the text, select the ID from either table). If you don't
want to see the text, just base the query on the main table, and use the
Lookup tab in the field properties of this field to change it from Combo Box
to Textbox, so you can see what is actually there. It is NOT necessary to
use a UNION query.


.

Relevant Pages

  • Re: Find Specific Record in database Table via VB code
    ... > value for the Atty_Num (primary key) field. ... I've attempted to use a macro calling a query to ... > I'm not sure if I need to use a query to get the record, then extract ... > overhead if I could read DPS_FR_ATTORNEY table directly, lookup the record ...
    (microsoft.public.access.formscoding)
  • Re: Basic Question for Lookups.
    ... However, especially in the early phases of setting up your Tables, you will probably need at times to look at their contents, and if so, you probably will want to define lookup properties on the foreign keys. ... The Query that I would suggest is similar to what the Lookup Wizard defines, except that I give mine a name, and I limit it to 2 fields instead of several. ... 1801550689 Michael Zachary Jackson ... I'm properly storing Prospect ID pk then FirstName then Middle then Lastname fields.etc. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Tip: Table design and query for bracketed lookup
    ... WHERE [Enter Bracket:] ... No rows would be returned by the query! ... If the "lookup" value is in a column of your query called Lookup, ... FROM RateTable RT1 ...
    (microsoft.public.access.queries)
  • Re: WHERE statement
    ... with basically all the info going to one table, except now the suppliers, ... "Jeff Boyce" wrote: ... and you can still use a combobox to list the lookup values. ... I know I get the ID field if I query against a 'lookup' ...
    (microsoft.public.access.gettingstarted)
  • Re: Understanding what makes Access tick
    ... > Query, but which is the subject of a table's lookup relationship. ... allow any "main" record..and "maybe" a child record. ... want here is a simply list of tasknumbers. ...
    (microsoft.public.access.gettingstarted)
Loading