Hi,

I am really new to writing code and am trying to do a simple lookup on a form in access but when i run it i keep getting the run time error code '424' which says 'Object is required'.

The code i have written is as follows:

Private Sub Combo21_AfterUp date()

If (Combo37 = qry_TasksStatus Test.Task) Then Text24 = qry_TasksStatus Test.Resource

End Sub

Can anyone...