Create A Command Button That Searchs For A Specific Record

[DAPOOLE]

Hi there,

Can anyone advise me on how I can create a command button in Access 2003 that searches for a specific record? I know you can create the default one through he wizard however that only searches on the priary key. The command button I'd like to code searches on a fields string.

Thanks in advance.

 

[John Big Booty]

Have a look at the DoCmd.FindRecord method.

 

[DAPOOLE]

Thanks. Any chance of a dummies example on how to create the search button that would search on the customers name?

 

[John Big Booty]

Have a look at the sample posted in this thread. Additionally have a look at this sample.