value lists

[sswan]

I have not worked with Access for a while and am stumped. I have a value
list for a field in a table. When I develop a form off that table, the
entire value list shows and I only want the one I selected from the list to
show. What step am I missing?

 

[John Nurick]

When this happens to me, it's because I used commas instead of semi-colons to
separate the values in the list, or maybe vice versa.

 

[sswan]

John, I tried changing but it still happens. I have one value list with
commas and one with semi-colons and they both show up on the form.

 

[B. Edwards]

Is the Display Control Property on the Lookup Tab in table design set to
List Box or Combo Box?

 

[sswan]

It's set to list box

Is the Display Control Property on the Lookup Tab in table design set to
List Box or Combo Box?