referencing text boxes from a form to a report

[binghamw]

i have managed to reference the text box just fine [from a form to a report].

However, I have a form called: "frmDept"

In this form, there are two cascading combo boxes, with 6 fields beneath them.

The form is based on a table called: "Layers"
Layers has a number of lookup columns in it specifically:

"keyword" which reads from the table "Keyword".

I have set it up so that in the table "Layers", it references the KeywordID but displays the Keyword.

In the form: "frmDept", one of the fields that is referencing a record, appears as the correct "keyword" (versus showing up as the KeywordID).

However, when I make a report from the exact same form, and I reference the textbox that the keyword is coming from, it shows up as the KeywordId (just a number).

It does the same thing when I am referencing a combo box.

Help!

 

[bradcccs]

I have set it up so that in the table "Layers", it references the KeywordID but displays the Keyword.

binghamw,

Using the "lookup wizard" or "lookup" option inside a table inevitably leads to these issues.

Tables should be considered as data storage only. You should not need to perform any display operations in a table, as users will not be looking at tables. All your display work can be achieved in forms / reports / queries etc. Thus avoid using the Lookup Wizard / Lookup options in Tables.

Looking for a quick fix? . . . .
If you have the KeywordID in the report, then you could adjust your underlying query to add the Keyword description. Alternatively, you could utilise a DLookup on the KeywordID.

HTH

Brad.