Combo Box Compile Error

  • Thread starter Thread starter Dinamo/Pistons
  • Start date Start date
D

Dinamo/Pistons

See code below

Private Sub Combo30_AfterUpdate()

Me.Child32.RowSource = "SELECT Form FROM" & _
" tableComplaintTypes WHERE ComplaintID = " &
Me.Combo30
Me.Child32 = Me.Child32.ItemData(0)

End Sub

I am getting a compile error for member not found...
I need some fresh eyes to look at this

Thanks
Alex
 
Child32 is the type of default name that Access would
assign to a Subform Control. A Subform Control does
not have a RowSource property, not does it have an
ItemData property, hence your compile error.

What are you trying to do?
 
This is a complaint database
There are 5 type of complaints, each type with different prespecs and
different questions
What I am trying to do is after I select the complaint type from a combo box
I am trying to load the corresponding subform with the questions for that
type of complaint

Thanks
Alex
 
Back
Top