can not use FindRecord with string

[john60]

i can get this to work

DoCmd.FindRecord "hello",,True,,True,AcAll

but not this

dim b As String


b="hello"
DoCmd.FindRecord b,,True,,True,AcAll

or again not this

Me!textbox9="hello"
DoCmd.FindRecord Me!textbox9,,True,,True,AcAll

can any one help please

[pbaldy]

Shot in the dark, but try

DoCmd.FindRecord "'" & Me!textbox9 & "'",,True,,True,AcAll

[Missinglinq]

As I said in your other post on this problem, I have no trouble with your second example, using the variable B. I've gnawed at this for a while, and got it to do what I'm telling it to, finding the Record with the textbox9 value. The problem with using a Textbox for this code is that the Access Gnomes are always going to find that value in the textbox9 on the Current Record! It's not going to go to another Record!

Rather than using a Textbox to enter the value, I'd use a Command Button together with the Inputbox Function, something like this:

Private Sub btnSearch_Click()

Dim SearchTerm As String
 
 SearchTerm = InputBox("Please Enter Search Term")

 DoCmd.FindRecord SearchTerm, , True, , True, acAll

End Sub

This appears to answer your needs.

Linq ;0)>