How search a record in a table by using VBA ?

[mac]

I am going to create a form where user will enter part number and then click
ok. Ok button should have codes to find the record in the table for that
particular part number.

What is the syntax for find a record ?

Thanks.

 

[Turner]

There are several ways. But, the easiest is
the "dlookup" command.

Dean

 

[Graham R Seach]

<<...the easiest is the "dlookup" command>>
And it is the most expensive!

Check the online Help for the FindFirst and Seek methods. You might also get
some joy from simply filtering a Recordset (I assume you actually want to do
something with the record(s) you find).

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html