enter parameter value problem..

[marklove]

good day



I have a problem regarding my project. I am using access 2007 to create a survey with 3 cascade comboboxes. Everytime i select a value in the first ComboBox a Enter Parameter appears, but it is working if i click the OK button.

here are my tables:

tblProvince
provinceID=Pk
ProvinceName

tblMunicipality
MunicipalityID=Pk
MunicipalityName
ProvinceID

tblBarangay
BarangayID=pk
BarangayName
MunicipalityID

CAN SOMEONE HELP ME?
any help is well appreciated

[June7]

Change the Municipality RowSource to:

SELECT MunicipalityID, MunicipalityName FROM tblMunicipality WHERE ProvinceID=[cboProvince];

The only code you need is:

Private Sub cboProvince_AfterUpdate()
Me.cboMunicipality.Requery
Me.cboMunicipality = Me.cboMunicipality.ItemData(0)
End Sub

[marklove]

Change the Municipality RowSource to:

SELECT MunicipalityID, MunicipalityName FROM tblMunicipality WHERE ProvinceID=[cboProvince];

The only code you need is:

Private Sub cboProvince_AfterUpdate()
Me.cboMunicipality.Requery
Me.cboMunicipality = Me.cboMunicipality.ItemData(0)
End Sub

Your codes made my day sir! thankyou so much! it works!....

[marklove]

it work but right now i can't save my record
i just want to save my record in a different table so how will i do that if my combobox is unbound?

[June7]

If you want record saved to Database table then bind comboboxes to fields of that table. That form's RecordSource could be only the Database table. Or change the SQL to:

SELECT Database.ID, Database.[UP-ID], Database.Province, Database.Municipality, Database.Barangay, tblMunicipality.MunicipalityName, tblBarangay.BarangayName, tblProvince.ProvinceName
FROM tblProvince RIGHT JOIN (tblBarangay RIGHT JOIN (tblMunicipality RIGHT JOIN [Database] ON tblMunicipality.MunicipalityID = Database.Municipality) ON tblBarangay.BarangayID = Database.Barangay) ON tblProvince.ProvinceID = Database.Province;