Unable to select items in a drop down box

G

Guest

I recently converted a database to a project. I have a drop down box on a
main form that I use to select items. In the Database, I could drop down
and select items using a Query as the datasource. In the Project, I can drop
down the same list but am unable to selet items using View as the datasource.
I found the Data Entry field set to NO so I changed it to YES. Now the form
goes blank. Any idea's how I can get the drop downs to work again in View?
 
G

Graham Mandeno

Hi Ernie

The DataEntry property won't help you. All it does is open the form in a
mode for adding new records - hence the form is blank.

I can think of three possible causes:

1. The form's AllowEdits property is set to "No"

2. The combo box's Locked property is set to "Yes"

3. The combo box is bound to a field in the form's recordsource that is not
updateable.
 

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

Label based on drop-down box selection 3
drop down not allowing selection 6
drop down box issues 1
auto-input text bx depending on 2 drops 4
Copy record in one form into a new pop-up form 0
Excel Excel: How do I put a formula in a drop down list 11
Filtered Drop Down Menu Based on Previous Drop Down Selection 1
Drop Down Box 7

Top