drop down lists and reports/exports

K

kraus012

I'm fairly new to Access 2007, and I'm having an issue with drop down lists.
I have a drop down list with 3 choices (done to avoid data entry errors).
When I create a report that includes this field, all 3 options show up in the
report where the one I've chosen during entry is highlighted. When I go to
export my report into Excel, the cells for that field are completely blank.
How can I change this so that only the option I've chosen shows up in both
the report and the Excel export?

Thank you for your help!
 
K

Klatuu

Are you using a Combo Box or a List Box?
Can you post the record source for the report and the control source
expression that causes the 3 values to show on the report?
 
K

kraus012

I think it's a list box. Are you referring to the control source and record
source from the design layout? I'm not a programmer, just an Access user, so
I'm not sure exactly what you're asking for.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop-down list that only shows relevant reports 3
report and drop down list? 4
Drop down lists 2
form drop down containing all my reports 2
Drop Down List 3
Form and lost drop down list 1
filtering one drop down to another drop down 5
Drop-down list to select relevant reports 2

Top