Event procedure reference help

[ppoindexter]

I am trying to reference a field in an updatable select query (based on 3 tables) to a combo box on a form and i get this message "Enter paramater value" "Name"

event procedure for combo box is shown below

Private Sub Combo_soldier_GotFocus()

If IsNull(Me.Combo_exercise) = True Then
MsgBox ("Please select Exercise")
Else
Me.Combo_soldier.RowSource = "select fld_soldier_id, Name from tbl_main where fld_event_id=" & Me.Combo_exercise
End If
End Sub

field referenced from query: Name: [fld_rank] & " & [fld_last]


The fields fld_rank and fld_last are from tbl_soldier but the fld used to look up a particular record (fld_event_id) is from tbl_main
the query is based on tbl_main, tbl_soldiers, tbl_rank

I think my problem has something to do with referencing the query but I cant figure it out.
Any help would be appreciated.

 

[jeremie_ingram]

Keep in mind that NAME is a reserved word in Access. Try calling it ClientName or FName, but not NAME.

 

[ppoindexter]

thanks
it's working now, but i have another problem
will try to work it out....