I have a combo to search for a surname, yet I have a few householders who have the same surname and first name, so if you click on the first one it comes onto the form, yet if you then click on the other one nothing happens....
What is going wrong?
My row source is:
SELECT DISTINCTROW [2001 2002 REGISTRATIONS].Surname, [2001 2002 REGISTRATIONS].[First Name], [2001 2002 REGISTRATIONS].[Landlords address] FROM [2001 2002 REGISTRATIONS] ORDER BY [2001 2002 REGISTRATIONS].Surname;
My after event is:
Sub Combo89_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[Surname] = """ & Me![Combo89] & """"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
Thanks
Ian
What is going wrong?
My row source is:
SELECT DISTINCTROW [2001 2002 REGISTRATIONS].Surname, [2001 2002 REGISTRATIONS].[First Name], [2001 2002 REGISTRATIONS].[Landlords address] FROM [2001 2002 REGISTRATIONS] ORDER BY [2001 2002 REGISTRATIONS].Surname;
My after event is:
Sub Combo89_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[Surname] = """ & Me![Combo89] & """"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
Thanks
Ian