rdavidmurphy
New member
- Local time
- Today, 09:53
- Joined
- Apr 16, 2011
- Messages
- 4
I have two simple Access 2007 tables and have successfully created a two field lookup using the wizard. I am able to see the two columns in the table or form, and can select and save records that I wish to bind. However, in my table or form display I can only see the second field although I included two fields widths, after using zero width for the bound ID column.
Lookup Properties
Lookup Properties
- Display Control: Combo Box
- Row Source Type: Table/Query
- Row Source: SELECT [Expats & Apartments].[ID], [Expats & Apartments].[Building], [Expats & Apartments].[Apartment] FROM [Expats & Apartments] ORDER BY [Building], [Apartment];
- Bound Column: 1
- Column Count: 3
- Column Heads: Yes
- Column Widths: 0cm;1.27cm;1.565cm
- List Rows: 16
- List Width: 2.831cm
- Limit to Width: yes
- Allow Multiple Values: no
- Allow Value List Edits: no
- List Items Edit Form:
- Show Only Row Source Value: no