Solved Printing Combobox Contents - Report (1 Viewer)

[doco]

I am using Office 365 on Windows 10 Pro machine.
I have two tables referenced having a 1:N relationship. The one side table has several fields that get populated using Lookup Wizard through a dropdown box as does the many side. The problem is one of the fields from the one side table insists on displaying, on the report, the ID# instead of the actual text. No other field having dropdowns does this.

As shown in the report rough draft


I suppose I could remove the primary key from the lookup tables. But none of the other fields print the ID in the report. Any help appreciated.
TIA

doco
KD7OCO

 

[arnelgp]

the Lookup value saved to the table is numeric (ID).
on report make this textbox unbound and just
use DLookup() to get the "text" value from the lookup table.

 

[theDBguy]

Hi. In case you haven't seen this, it explains why we don't recommend using the Lookup Wizard.

The Access Web - The Evils of Lookup Fields in Tables

As for your report, use a query joining your lookup tables for your report.

 

[The_Doc_Man]

My first thought is that you could compare the properties of the lookup that fails against one that works. I would verify that the correct column was bound. Just because the wizard set it up for you doesn't mean that you can't go back and adjust it.

EDIT: However, I ALSO agree with theDBguy - if you have tables holding the desired values, those lookup-table dropdowns can easily be replaced by combo boxes which ALSO have a wizard - and which give you pretty good control over what you are seeking.

 

[arnelgp]

The Access Web - The Evils of Lookup Fields in Tables

there is no Evil with access and lookup fields.
avoid it if you can't handle it.

 

[doco]

the Lookup value saved to the table is numeric (ID).
on report make this textbox unbound and just
use DLookup() to get the "text" value from the lookup table.

DLookup() gives a circular reference error

 

[doco]

Hi. In case you haven't seen this, it explains why we don't recommend using the Lookup Wizard.

The Access Web - The Evils of Lookup Fields in Tables

As for your report, use a query joining your lookup tables for your report.

Instead of using report wizard?

 

[theDBguy]

Instead of using report wizard?

You can use the report wizard, just don't select the table as your data source. Create a query that joins your main and lookup tables and select it in the wizard.

 

[doco]

Thanks all! I used a query for the form wizard. Yet, I had to create and recreate the report a couple times before the text actually showed up in the field instead of the id.

 

[theDBguy]

Thanks all! I used a query for the form wizard. Yet, I had to create and recreate the report a couple times before the text actually showed up in the field instead of the id.

Practice makes perfect. Good luck with your project.