Thanks again! i am getting there. I

[cjjc]

Thanks again! i am getting there. Ive set up the separate module so ive got pass the undefined function problem.

re passing the values to the public variables - confusion! do i do this within the form's module? the query runs and states that it is updating the field so thats all ok, but im still getting blank fields. is it because the variables are being selected from a combo box which is using a lookup table? i need to use the lookup as the values could change in future. I have set a command button for the user to click once the values have been selected in the combo boxes, and have used this code as suggested for the click event.

Public Sub Command9_Click()

strContname = Me.cboContractor
strUserID = Me.cboUser

DoCmd.OpenQuery "Query1"

End Sub

yours frustratedly!
c

 

[cjjc]

ignore this post, sorry chaps, it is a continuation of another from another forum!