We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

FindFirst Run-Time Error 3070:

T1080
T1080 asked
on
Medium Priority
515 Views
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

Comment
Watch Question

Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007
Commented:
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thanks for the help.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.