Go To Specific Record using VBA

J

John

Hi,
I am currently trying to use VBA to code a command button
on a form in the following manner: While the current
record is visible, I would like to code the OnClick
funtion to go to the last record where a specific field
contains a specific entry, like

forms!Activity!Company=last entry for "Enron"

Thank you in advance!
 
Top