Can't select - Combo Box

S

Stu

Access 2003. I have a subform that has a record source query. The query
joins two tables. DeFault View: Continuous. Allow Edits, Adds, Deletes are
all Yes. Data Entry = Yes. Locked = No, Enabled = Yes. Most other form
properties are default.

I successfully populate the ClassTitle ComboBox's Row Source with the
following statement using the OnCurrent event: Me.ClassTitle.RowSource =
DLookup("text2", "tblMenusVariables", "sequence = " & iSeq & " and reference
= 'DAY'"). The RowSourceType is Value List for the ClassTitle ComboBox.

Problem: When I open/view the form I am uable to select a different value
from the ClassTitle ComboBox list and the New Record icon is grayed out. How
can I select a new value from the list and why is the new record icon grayed
out? Must be something simple!!!
 
S

Stu

Cancel this question. Apparently the problem was with using a query data
source involving two tables. I have reworked the issue and would like to
close the case.
 

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

Need combo box to refresh when moving to new record 2017 1
Can't select from list box 3
Combo Box Mouseover selection 4
DEFAULT VALUE IN COMBO BOX 3
Blank Combo Boxes on Continuous Form 7
Combo box record source in datasheet 1
Combo box blank due to record source query only selecting records marked as active 1
Query result shows on form but not in VBA code Me.ControlName 5

Top