Search Records in VBA

[Jollywg]

I'm trying to search and display an record to a form using VBA Coding. here is what i have so far.

DoCmd. SearchForRecord acActiveDataObject, "tblIV", acFirst, patientID

tblIV is the name of the table i want to search in, and patientID is an integer variable that i have a value given to it in a different form that is being passed to this form (i know for a fact that the value is being passed correctly).

[ADezii]

I'm trying to search and display an record to a form using VBA Coding. here is what i have so far.

DoCmd. SearchForRecord acActiveDataObject, "tblIV", acFirst, patientID

tblIV is the name of the table i want to search in, and patientID is an integer variable that i have a value given to it in a different form that is being passed to this form (i know for a fact that the value is being passed correctly).

You should definately benefit from reading this previous Tip of the Week:
How to Find a Record Programmaticall y

[Jollywg]

Thanks worked like a charm!

[NeoPa]

Have you considered simply applying a filter to the form that only allows the record you want?

[missinglinq]

This is a new command only appearing in Access 2007. It's always a good idea to include the version number when posting questions, but it's especially important when you're using this latest version, as many things are different in it and only a small subset of the members here are running it.

As for the command you're using, the code you posted has a space between DoCmd. and SearchForRecord, which it shouldn't, and you really haven't stated what problem, if any, you're experiencing, which you really should always do.

Although, as recently documented here on bytes, NeoPa's ESP is on fritz, his advice is well worth taking.

Linq ;0)>