Re: Wayne-In-Manchester

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Do you have a control on the subform named License Tag Number? Probably not. Maybe something close like License_Tag_Number?

And if the line fails, what error message do you get? The error message often points the problem.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


Raymond wrote:
My reply failed let me try again.

Private Sub txtSearchReg_AfterUpdate()
Dim rs As DAO.Recordset
Dim frmAny As Form

If Len(Me.txtSearchReg & "") <> 0 Then 'Optional line
Set frmAny = Me.TEST2.Form
Set rs = frmAny.RecordsetClone


rs.FindFirst "[License Tag Number] = " & Chr(34) & Me.txtSearchReg & Chr(34)
'rs.FindFirst "[License_Tag_Number] = " & Me.txtSearchReg
***The above live failed, so I input going with one of the text finds***

If rs.NoMatch = False Then Me.Bookmark = rs.Bookmark

***this line now fails, should there be quotes?
frmAny.[License Tag Number].SetFocus


Me.txtSearchReg = Null

Else
'If desired
'Insert alternate code if txtSearchReg is null
End If 'Optional line

End Sub
my txt box has no data just the after event

My list27 row source is the table visitorlog table in license order bound by column 4, which is licence tag, visible column, actually column 5 in the table. no control source

I really appreciate your help.

.

Relevant Pages

  • Re: org.apache.axis.AxisFault.makeFault(AxisFault.java:101)
    ... you're calling sent back some ill-formed XML: Missing the end tag, ... exactly as the error message indicates. ... getServiceIdsReturn> ...
    (comp.lang.java.programmer)
  • Re: ASP.NET applications not working??
    ... The one thing I can think of to help you get the error message, ... setting the customErrors tag in the proper web.config file. ... a "web.config" configuration file located in the root directory of the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: org.apache.axis.AxisFault.makeFault(AxisFault.java:101)
    ... calling sent back some ill-formed XML: Missing the end tag, ... as the error message indicates. ... getServiceIdsReturn> ...
    (comp.lang.java.programmer)
  • Re: Regular Expression question
    ... It also fails to match any image tag where the src attribute is quoted ... using single quotes, or where the src attribute is not enclosed in quotes ... Handle all of that correctly in the regex and the beautiful soup or ...
    (comp.lang.python)
  • Re: object reference not set to an instance of an object
    ... Do you have the runat="server" tag in your btnEdit? ... Object reference not set to an instance of ... >> however I'm getting the error message in my subject heading. ...
    (microsoft.public.dotnet.framework.aspnet)