weird lookup behavior

[Jacquie]

I have a table called tClasses with Code as the Primary Key. I have another
table called tSchedule that does a lookup of the Code (I used the lookup
wizard, selected tables, selected code). When I view the table, there is a
lookup box, but it's blank -- none of the codes appear in the list. I've
deleted this and restarted several times, but no luck. What would make a
lookup combo box not show the values?

Both are text fields
both have 3 as the field size
the input mask for code is AAA

Thanks!

 

[John W. Vinson]

I have a table called tClasses with Code as the Primary Key. I have another
table called tSchedule that does a lookup of the Code (I used the lookup
wizard, selected tables, selected code). When I view the table, there is a
lookup box, but it's blank -- none of the codes appear in the list. I've
deleted this and restarted several times, but no luck. What would make a
lookup combo box not show the values?

Both are text fields
both have 3 as the field size
the input mask for code is AAA

Thanks!

Two suggestions:

Use Forms to work with your data, not table datasheets.
Avoid the Lookup Wizard like the plague it is:

http://www.mvps.org/access/lookupfields.htm


If you base a Form on tSchedule, you can easily put a Combo Box control on the
form; its Rowsource should be tClasses, or a query sorting tClasses
appropriately; the bound column would be that containing the Code; the
Controls Source would be the Code field in tSchedule; the column count and
ColumnWidths properties would be set to display the course name but store the
code.

John W. Vinson [MVP]

 

[Jacquie]

I have done hundreds of databases using the lookup wizard in tables and this
is the first time I've ever had a problem. Why is the list not showing up?

 

[John W. Vinson]

I have done hundreds of databases using the lookup wizard in tables and this
is the first time I've ever had a problem. Why is the list not showing up?

<shrug> Because the lookup wizard defined it incorrectly, I'd guess. Check the
RowSource, ColumnCount, and ColumnWidths properties of the combo box and
adjust as needed.

John W. Vinson [MVP]