I'm trying to create a form where there will be two drop down boxs. The available choices in the 2nd dropdown will be dependant on what you choose in the first dropdown. For instance If the first field allowed you to choose the state. The 2nd field would then give you a list of cities in that state that you could choose from. I'm having a tough time trying to set this up and any advice on how to this would be helpfull.

thanks in advance.
Mike

Hi Mike:

Private Sub cboState_AfterUpdate()
    Me.cboCity.RowSource = "SELECT CityName FROM tblCity WHERE StateID = " & cboState.Column(0)
End Sub

HTH,

Bob

You may also wish to do a search at the MS Access Developer Center for "cascading combo boxes."

http://www.msdn.microsoft.com/office...anding/access/


mmcdonal

Perfect. Thanks for the help guys.