MsgBox and findrecord (1 Viewer)

[bodvoc]

Hi All

Does any one know a way of getting docmd.findrecord to use a msgbox that prompts for the search criteria??

Or am I barking up the wrong lamp-post, just need a simple way to find a person or address in a Doctors db.

Thanks

Bodvoc

 

[dcx693]

You can't force DoCmd.FindRecord to use MsgBox, but you can use the MsgBox function to request info from the user that can then be used by FindRecord to find your record. Look up the MsgBox function in the Access online help. In addition to looking at the FindRecord method, you should also look at the help topic for the FindRecord macro action, as they macro help tends to be more thorough.

 

[soundsfishy]

Hi BodVac,

you will find a sample of an input message box in this sample.

 

[bodvoc]

Thanks Guys

Thanks guys will check it out

Bodvoc