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

Finding a record using criteria for bound controls

I am trying to add an extra textbox/combo to help me insert search criteria so that users can go to a particular record without having to resort to the use of findnext and findprevious only.
I tried to do it like this:

Private Sub FindSICode_AfterUpdate()
    DoCmd.FindRecord Me.FindSICode
End Sub
This keeps on giving me the error 'Ther command or action "FindRecord" isnt available now'
This can easily be implemented when u r dealing with unbound controls but I would like to find out if its possible to do it with bound controls.Thanx a lot
  • 2
1 Solution
cant u do it like

datacontrol.datasource = "select * from table1 where field1='" & text1.text &"'"
mebbe u mite need to do a datacontrol.refresh or requery also.

also, text1 would be the place where u enter ur search criteria for field1
briokasAuthor Commented:
Tried that method it didnt help me I guess the only alternative is to use unbound controls
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

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