FindFirst Run-Time Error 3070:

Posted on 2009-02-12
Last Modified: 2013-11-27
I get a run time error that says:Microsoft Access Database engine does not recognize 'txtRequest' as a valid field name or expression.  Any Ideas why?
Private Sub txtDefinitions_Click()

DoCmd.OpenForm "frmRequestDefinitions", acNormal

    Dim GoHere As String



    GoHere = "[txtRequest]='" & Forms!frmAddDifferent!cboRequest & "'"

    Forms!frmRequestDefinitions.Recordset.FindFirst GoHere


End Sub

Open in new window

Question by:T1080
    LVL 75

    Accepted Solution

    txtRequest I assume is a control and not it fact a field name, which is what would be required as the first part of a WHERE clause in a FIndFirst expression.

    rst.FindFirst "[SomeFieldName] = " & <Some criteria expression >


    Author Closing Comment

    Thanks for the help.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
    This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now