Grouping Reports by Field Lookup (Column 1) (1 Viewer)

T

tdefreest

Registered User.

Local time

Yesterday, 19:29

Joined

Dec 16, 2015

Messages

23

• Jun 21, 2016

• #1

Hello,
I am seeking to group a report using a Field Lookup Table. The problem, is when I call the field in the header, "MarketLookup", the result is the ID associated with the field. For example, "2", instead of "Commercial".

Now, usually in VBA, I would use the expression: Me.MarketLookup.Column(1), which would return the column 1 instead of the ID.

Does anyone know how to apply these same principles to Reports?

Thanks,

 

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 00:29

Joined

Jul 9, 2003

Messages

16,282

• Jun 21, 2016

• #2

Use a combo box on the report.

 

T

tdefreest

Registered User.

Local time

Yesterday, 19:29

Joined

Dec 16, 2015

Messages

23

• Jun 21, 2016

• #3

I tried implementing using a ComboBox and inserted the following SQL into the Row Source:

Code:Copy to clipboard

SELECT tblMarketsNameList.[MarketNameID], [tblMarketsNameList].[MarketName] FROM tblMarketsNameList ORDER BY [MarketName];

No luck, it still returns the ID field.

 

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 00:29

Joined

Jul 9, 2003

Messages

16,282

• Jun 21, 2016

• #4

Have a look at the FIRST video on this page:-

Videos - Combo Box

 

Last edited: Jun 23, 2016

T

tdefreest

Registered User.

Local time

Yesterday, 19:29

Joined

Dec 16, 2015

Messages

23

• Jun 23, 2016

• #5

Thanks Uncle Gizmo, I've never used combo boxes on reports before! It's working now.

I had to adjust the Column Count and the Column Widths.