I can't get a second combo box data to be defined by the first combo box.

[lewisoh]

I am using Access 2007 trying to use combo box 1 named zone to define which data is shown in combo box 2 named cell. The code is as follows;

Private Sub Zone_AfterUpdate()
    ' Update the row source of the cboCell combo box
    ' when the user makes a selection in the cboZone
    ' combo box.
    Me.cboCell.RowSource = "SELECT Cell FROM" & _
                               " tblCells WHERE Zone = " & _
                               Me.cboZone & _
                               " ORDER BY Cell"
 
    Me.cboCell = Me.cboCell.ItemData(0)
 
End Sub

The error message I get is " Compile error
Method or data member not found.

[dsatino]

I think you need to requery cboCell after you set the rowsource

[Rabbit]

Which line is the error on?

[lewisoh]

Hello Rabbit,
It is on "Me.cboCell.RowSource" is highlighted in blue. This is my first attempt at building a database like this. I have not had any classes on this so I am pretty much flying blind here. Thanks for helping

[Rabbit]

Check the names of your controls. You said the combobox is named cboZone, however, your event is Zone_AfterUpdate and not cboZone_AfterUpdate. So it's likely one of them is wrong.

[lewisoh]

I am attaching more information so you can see what I have created. I can't immediately find my error, but then again I ma rather new to all of this.

Database Parts
Tables
Zones ID Autonumber Key
Zone Text

Cells ID Autonumber Key
Cell Text
Zone Text

Category ID Autonumber Key
Category Text

Form
Parts ID Autonmuber Key
Zone Text Combo Box
Select Zones.Zone, Zones.ID From Zones ORDER BY Zones.Zone;
Cell Text Combo Box
Select Cells.ID, Cells.Cell, Cells.Zone From Cells ORDER BY Cells.Cell
Unit Text
Category Text
Item Text
Model Text
Manufacturer Text
Description Memo
Purchase Currency
Attachments Attachment

[Rabbit]

Thanks for the extra info but my suggestion doesn't change from post #5. The names of your controls on your form don't match what's in your code, so that's probably where the issue lies. Fix the names by either renaming the controls or fix the code by using the correct control name.