Drop down based on Access Database needs to be blank on open

H

Hilary

Hi:

I have a set of 4 cascading drop downs based on an Access Database--Product,
Condition, Shape, and Throughput. I have filters in place to display only
unique values and all is working well, except that when I preview the form
the first drop down, Product, displays the first product in the datasource. I
would like it to be blank. Is this possible?

Thanks,

Hilary
 
F

Franck Dauché

If your first drop-down should also be blank, maybe it should be gone from
the Print View. What you could do is create another view (a print view) for
your main view. On that print view, you could copy paste the content of your
data entry view and remove the first drop-down if needed.
You just link you new Print View through the "View Property"button \ Print
Settings Tab.

Hope that helps.

Franck Dauché
 
H

Hilary

Thank you for your reply--it turns out that my problem was related to a
change I had made to the properties of one of my query fields early on and
subsequently forgotten about--that is why in previews of the form, that first
dropdown showed up with an item alread selected. I changed the default value
back to blank and now all is well.

--Hilary
 
Top