blank list box combo box

[Phil Boorman]

I am trying to add a list box to my existing datasheet. I built a second
table with the selections that I want to pop up then under the lookup tab
selected that table under Row Source however when I check it in datasheet
view the down arrow for the selection is there but the boxes are all blank
( not the fields I built in the table).

Any ideas?

Thanks,

Phil

 

[Tom Wickerath]

Hi Phil,

In form design view, click on View > Properties to display the properties dialog. Select the
listbox. You should see the name of this control in the blue title bar of the properties dialog.
Click on the Format tab. Verify that the Fore Color is not the same as the Back Color, for
example, white on white.

Tom
________________________________________


I am trying to add a list box to my existing datasheet. I built a second
table with the selections that I want to pop up then under the lookup tab
selected that table under Row Source however when I check it in datasheet
view the down arrow for the selection is there but the boxes are all blank
( not the fields I built in the table).

Any ideas?

Thanks,

Phil