Hello Everyone,

Please help me.

I am building a subform (using table [Sub Objects, Sub Object Titles]) which has Subobject (combo box) and Title (list box) fields on the Form.
On Form Subobject field, I select subobject and title from [Sub Objects, Sub Object Titles] because I want to user see these, so I put “Bound Column”=2; Then on Title field, it should show the title which relates with Subobject. Here is my code:
***
Private Sub SubObject_AfterUpdate()

Me.Title.RowSource = "select Title from [Sub Objects, Sub Object Titles] where SubObject=" & Chr(34) & Me.SubObject & Chr(34)
End Sub

But I got this error message:
The expression after update you entered as the event property setting produced the following error: A problem occurred while Microsoft office Access was communicationg with the OLE server or activeX Control

Thanks,
Cindy

Cindy,

Sounds like you are trying to create cascading controls.

See this example:
Cascading Combo Boxes Using 2 Tables

Note that the bound column of a combo box is the column that is stored. The column that is displayed is the first column with a display width greater than 0".

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

Hi HiTechCoach,

Thanks again for your response. I think you are right, but my two fields are in the same level (in the datasheet). For example: PK is combox, and RowField is list box. if PK=1, then RowField=Row1; if PK=12, then RowField=Row6
(my example, PK and Row1 are one to one relation).

Thanks,
Cindy

You should always set the bound column to be the field that is the primary key for a list box or combo box that uses a table as the row source.

If the combo box and list box both have the same table as the row source then they will both be bound to a column which is the same primary key field in the table.

The difference between the combo box and list box will be in which column (field from the table) is displayed.

Would you please post the table structure (fields) for the table [Sub Objects, Sub Object Titles].

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

Thanks, HiTechCoach.
Here is the table fields:

Field Name Data Type

SubObject text
Title text
rate currency
AllowedtoPlan yes/no
PlanGrantOnly yes/no


Thank you very much,
Cindy

What field is the primary Key?

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

SubObject is the primary key.

Thank you so much HiTechCoach!

Cindy

Hello HiTechCoach,
My Master Form project and subform projectDetail link by hiding field ID which is the autonumber and primary key from project table and projectdetail table. These forms are for adding a new record. The Master Form has Schoolyear, projectname, projectManager........some fields use value lists, some fields use query to get value come from another table fields. When the record has been saved, they will be saved in project table. For sumform projectdetail, SubObject and Tilte fields use the value come from [Sub Objects, Sub Object Titles], and also on this subform, I also have planningAmount and descr fields. Since the SubObject (comb box-drop down) and Title (I think I should use text box instead of list box) come from [Sub Objects, Sub Object Titles], so I want this: When user choose a value from Subobject drop down list, the Field--Title shows up the value which the Subobject = the value which user chose. Because on the table [Sub Objects, Sub Object Titles], Subobject field is primary key and it is unduplicated field. on the subform, planningAmount and descr fields are text box, data entry by user.

if my explaining is still not clear, please let me know.

Thanks,
Cindy

Are you just wanting to show the "Title" for the select SubObject in the combo box?

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

Thanks, HiTechCoach.
Yes, only show the Title which SubObject selected from SubObject Combo box. Rest of the fields in the subform are the data entry fields.

Thanks,
Cindy