Help with Form in a Form and text box

mrrayj60

Registered User.
Local time
Today, 03:05
Joined
Sep 3, 2009
Messages
103
I have a form(single) with a subform(continuous) that contains a listbox.
The main form has a txtSearchReg box to enter a license tag number and I want the list box to display all matches found from a table, visitorlog.

This code in the after event gives me an error method member not found.
The list box will not display the wanted records, but displays all records in the table. Any help on this would be appreciated

Link childs are both License Tag Number


Private Sub txtSearchReg_AfterUpdate()
Dim rs As Object
Set rs = Me.RecordsetClone
rs.FindFirst "[License_Tag_Number] = " & Me.txtSearchReg
If rs.NoMatch = False Then Me.Bookmark = rs.Bookmark
Me!License_Tag_Number.SetFocus
Me.txtSearchReg = ""
End Sub

Listbox: List27
'Control Source empty
'Row Source Type Table/Query
'Row Source Visitorlog Query
Column count is 4, bound by column 1 (license Tag Number)


I've been trying to solve this for a few days so any help would be great.
Thanks
Ray :confused:
 

Users who are viewing this thread

Back
Top Bottom