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
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