Combo box won't accept value

S

Sandy

Hello -

I have a combo box that shows all the values I need in the drop down list,
but wont allow me to select any of them, leaving the combo box blank.

The combo box is in the form header, and I have an "on change" event that
updates the filter for the record in the form.

I have the exact same combo box / event on another form and it works
perfectly. I have confirmed that the Enabled is "yes" and the Locked is "no".

Any ideas?

Thanks
sandy
 
A

Al Campagna

Sandy,
The Change event fires for every character entered.
Try using the AfterUpdate event of the combo to filter your records. It only fires
after the whole value has been updated.
Of course, make sure your combo is Enabled and not Locked.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

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

Sandy

Hi Al -

I removed the event and re-saved the form. The data form the list will still
not go into the combo box....

sandy
 
A

Al Campagna

Sandy,
Let's just deal with the combo not accepting a value from the dropdown
Did you check the Enabled and/or Locked of the combo?
What is the query and fields (RowSource) behind your combo?
Describe the combo properties (Name, NoOfCols, ListWidth, ColumnWidths, BoundColumn
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

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

Sandy

OK - Here goes:

COMBO BOX
Row Source Type: Table/Query
Row Source: SELECT DISTINCT Boards.Board_ID,
Q_BoardTravellerSelect.BoardName FROM Boards RIGHT JOIN
Q_BoardTravellerSelect ON Boards.Board_ID=Q_BoardTravellerSelect.Board_ID
ORDER BY Boards.Board_ID DESC;

Name: BoardSelectDD
Control Source is blank
Col Count: 2
Bound Col: 1
Col Widths: 0", 2"
List rows: 8
List Width: 2"
Visible: Yes
Enabled: Yes
Locked: No
Limit to List: Yes
AutoExpand: Yes

FORM
Query that the form is based on: Q_BoardTravellerSelect
Allow Filters: Yes
Allow Edits: No
Allow Deletions: No
Allow Additions: No

Continuous form

Again, the strange thing is that this exact drop down works on another form!

Thanks Al!
sandy
 
R

Ron2006

Change your allow edits to Yes.

If there are fields on the form that you do NOT want changed then you
will need to lock them.

Ron
 
S

Sandy

Hi Ron - this worked!

I made the form Allow Edits: Yes and made the fields themselves to Locked:
Yes.

Thanks so much :)

sandy
 
R

Ron2006

You are welcome.

That has bitten me before, that is why I recognized it.

Have a great day.

Ron
 
Top