passing a record inbetween forms

[Guest]

Hello I just started using Access 2000.

In datasheet view of FormA, when the user double clicks the record selector
i would like that record (the current record?) to load in FormB. Thereby
having now two windows open, FormA in the background in datasheet view and
FormB in the foreground in form view. from what i gather,the code might go
something like..

on double click event of FormA
docmd.open FormB
docmd.gotorecord

but i dont know how to pass the current record from formA to formb.
much less restrict formb to just that record (if possible). Im stuck on
understanding recordset manipulation in Visual basic.


ps: anyone know of a good .pdf or online VisualBasic/access manual ?

 

[Rick Brandt]

Hello I just started using Access 2000.

In datasheet view of FormA, when the user double clicks the record
selector i would like that record (the current record?) to load in
FormB. Thereby having now two windows open, FormA in the background
in datasheet view and FormB in the foreground in form view. from what
i gather,the code might go something like..

on double click event of FormA
docmd.open FormB
docmd.gotorecord

but i dont know how to pass the current record from formA to formb.
much less restrict formb to just that record (if possible). Im stuck
on understanding recordset manipulation in Visual basic.

The command button wizard has an option that does exactly this. Just use that
and then copy the code to your double-click event. Not sure the record selector
can be the thing you double-click though.

 

[pfd]

½Åºó¸ú·´¶Ô

 

[Larry Daugherty]

Look in Access Help for OpenForm method.

You won't need the gotorecord

 

[Guest]

HA ZA! Brilliant!

Rick and Larry thank you!!

im gonna add you to my xmas list