SearchForRecord statement

[crowegreg]

I'm needing to search for a record on a bound form, then display the record. Here's what I have right now:

variable for search is firstboxloc
field name to search on is boxloc



DoCmd.SearchForRecord , "", acFirst, "[BOXLOC] = " & "'" & firstboxloc & "'"

When I'm toggling through, my variable has the correct value, but when the record is displayed, the first record within the table is being displayed.

[Missinglinq]

What is the Datatype of BOXLOC?

If the Datatype is Text

"[BOXLOC] = " & "'" & firstboxloc & "'"

should be

"[BOXLOC] = '" & firstboxloc & "'"

If the Datatype is Number

it would be

"[BOXLOC] = " & firstboxloc

Also, where do you have this code?

Linq ;0)>

[crowegreg]

Thanks for the reply.
Boxloc is text.

I entered your code, "[BOXLOC] = '" & firstboxloc & "'" , and it still did not work properly.

Previous to this searchforrecord statement, I have two loops that are adding records to a table. Here's an example of the boxloc fields for the new records:
100A1
100A2
100A3
100A4
100B1

So, after adding all the records, I want the seachforrecord to go to the first record created.

[Missinglinq]

Is the Form you're doing this in Bound to the Table that these Records have been added to? If so, you'll have to use

Me.Requery

before issuing your

SearchForRecord

Command.

If not, you'll have to use something else, like the DLookup Function, where you can specify the Recordset to search.

BTW, your syntax is now correct, with BOXLOC being Text.

Linq ;0)>

[crowegreg]

The requery fixed the problem. Thanks!!

[Missinglinq]

Glad we could help!

Linq ;0)>