combobox misbehaving

[Brendanpeek]

hello

i used the combobox wizard to creat a combobox which displays values from a
query i made during the wizard the values were displayed but once it has
finished the combobox no longer display anything in the list

 

[Al Campagna]

Brendanpeek,
While you can use a table as the RowSource of a combobox, usually the
preferred source is a query, against your table.

In form design mode, look in the Properties of the combobox under
RowSource.
Place your cursor in the text box associated with RowSource, and hit the
3 dot button on the right of that text box.
You are now looking at the query design grid for the combobox.

If you run that query from the query design mode... does that query
deliver any records? Use the query design mode to adjust/correct the
query/criteria so that it returns the records that you want. That's step
one.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."