DoCmd.GoToRecord

  • Thread starter Thread starter Gary Robinson
  • Start date Start date
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
 
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
 
Back
Top