I have a form, ClientLookupFrm which has combo box ClientLookupCmb on it. I would like to select a value on the client lookup combo box and have it run the ClientItemQry with parameters. The parameter is that the bound column on the combo box goes to one of the values on the query, ClientAutoID. I have updated the afterupdate value to read:
Private Sub ClientLookupCmb_AfterUpdate()
DoCmd.OpenQuery ("ClientItemQry", , ,)
WHERE "ClientAutoID = " & Me.ClientLookupCmb
But this is not working. I clearly don't know VBA and am just fumbling through here, so please help! I have put the criteria
on the query (which runs well if I put the actual value in as a criteria instead of the code).