• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 463
  • Last Modified:

FindFirst Run-Time Error 3070:

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

0
T1080
Asked:
T1080
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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 >

mx
0
 
T1080Author Commented:
Thanks for the help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now