DoCmd.GoToRecord

G

Gary Robinson

Hi All

I need help with the following VBA function

I have two forms open, the first is a list of the records in the table, and
the second is the records displayed one per screen, and I would like to
double click a record on the first screen, and it open in the second screen.
I have tried using the filter option on the second form, but I would like it
to goto the record rather than filter the others out.

I have tried using the DoCmd.GoToRecord [objecttype, objectname][, record][,
offset] method, specifying GOTO and using the offset part to specify a
record number, the problem being I don't know how to extract the record
number from the first form!! If anyone can help that would be great!! Or
if you think there is an easier way I can do this, and help would be
appreciated!!!

Thanks in advance


Gary
 
A

Alex Dybenko

with GoToRecord you can really find record. you can use Docmd.FindRecord,
where you set criteria to find based on a selected record in a first form

Also you can use Form's Recordsetclone property, you can look in online help
for an example using it
 
Top