updating two fields from a combo box?!

[alejo]

i know i should not be asking..... but i am!
ok, i am trying to make a simple database (real Simple) it will store publications, just the volume and issue numbers and also their print cycle (ie. monthly, weekly.....) all i am trying to do is make a form that when an individual opens the form to enter a publication all they need to do is select the publication from a combobox and its print cycle is automgicaly updated. i am very NEW, like still shiny and squeeky new. i tried this code but it did not work... i think i am getting stuck in the making of the tables?!!

Private Sub Combo0_Change()
With Me(Publication)
If IsNull(Me!Publication) Then
    .RowSource = ""
    Else
        .RowSource = "SELECT [PrintCycle] " & _
                     "FROM TblPrintCycle " & _
                     "WHERE [PrintCycle]=" & Me!Publication
    End If
    Call .Requery
End With
 
End Sub

[MMcCarthy]

If PrintCycle is a text field the following should work.

Private Sub Combo0_Change()
With Me(Publication)
If IsNull(Me!Publication) Then
    .RowSource = ""
    Else
        .RowSource = "SELECT [PrintCycle] " & _
                     "FROM TblPrintCycle " & _
                     "WHERE [PrintCycle]='" & Me!Publication & "'"
    End If
    Call .Requery
End With
 
End Sub

Mary