FindRecord (1 Viewer)

[Ashen]

I'm having some problems using the FindRecord function. I have a form which as a TextBox called fooBox. fooBox takes an input, and when button fooButton is pushed, it is supposed to find the record. The problem is, is that the Event Module for onClick on fooButton doesn't work.

I have it defined as follows:

DoCmd.FindRecord fooBox.Value, acEntire, False, acSearchAll, True, acAll, False

I did some testing to see if fooBox.Value is legit by MsgBox'ing the value. It seems fine. I also replaced the fooBox.Value argument with an element that I knew existed in a field...-that- worked. It seems, if I have a variable for the first argument, it doesn't work. What's up with this?

 

[A real begineer]

From what you have typed it would appear the .value is upsetting the applecart.

Try:

DoComd.FindRecord foobox,etc

I reckun this'll fix it.