Get BOUND VALUE rather than DISPLAYED value

[Confused Report maker]

I am running a Query that pulls from a FIELD called BANK in a TABLE called
ACCOUNT INFORMATION.

The field BANK shows the actual name of my selected bank when viewed in the
query.

In the REPORT ... the BANK Field shows the BOUND VALUE.

How do I get the REPORT to actually show the DISPLAYED rather than the BOUND
value?

Thanks.

 

[Rick Brandt]

I am running a Query that pulls from a FIELD called BANK in a TABLE called
ACCOUNT INFORMATION.

The field BANK shows the actual name of my selected bank when viewed in the
query.

In the REPORT ... the BANK Field shows the BOUND VALUE.

How do I get the REPORT to actually show the DISPLAYED rather than the BOUND
value?

Get rid of the lookup field in your table. It will cause a bunch of headaches
just like the one you have now. The table that contains the lookup display
value needs to be included in the query for the report so you can pull in that
field.

 

[Confused Report maker]

OK .... THERE IS A TERRIBLE PROBLEM. PERHAPS IT'S A BUG IN ACCESS 2007.

I spent some time trying to get my data back after destroying and
re-establishing relationships ... Everything I've done is in futility
because I either lose the information .... cause an error ... or get stupid
freakin' BOUND VALUES again.

HERE is what I'm trying to do.
************************


I have these tables:

BANK INFORMATION ---- Primary Key ID, Column -- BANK
ACCOUNT INFORMATION -- Primary Key ACCOUNT NICNKNAME, Column -- BANK

I have this FORM:
ENTER ACCOUNT INFORMATION

I have this relationship:
[BANK INFORMATION].ID is a ONE to MANY relationship with [ACCOUNT
INFORMATION].BANK

On the Form I want the user to have the opportunity to select from ALL
available BANKS.

When I use this query:

SELECT [BANK INFORMATION].ID, [BANK INFORMATION].BANK FROM [BANK
INFORMATION]

The user gets the opportunity to enter the bank of their
choice but the table displays a numerical value rather than a Bank value.


If I use the query: SELECT [BANK INFORMATION].BANK FROM [BANK
INFORMATION] The FORM shows a bunch of empty blanks.