[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference bump::msaccess

Title:MSACCESS
Moderator:BUMP::HONER
Created:Tue Dec 01 1992
Last Modified:Mon Jun 02 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1661
Total number of notes:6339

1624.0. "How to pass a form to another form" by ROCCER::JHA () Thu Jan 23 1997 11:31

T.RTitleUserPersonal
Name		DateLines
1624.1Passing values from form to formNETRIX::"[email protected]"Lee FasoliThu Jan 23 1997 15:138
1624.2Duplicate form, use filter on OpenFormNSIC00::KLERKThunderbirds are GoFri Jan 24 1997 03:1216
   You could have the second form based on the same query or table as the
   first form.
   Then find out what record is currently displayed on the first form and
   open the second form with a DoCmd.OpenForm "frmCopyForm" and in its
   filter argument specify "[keyfield] = keyvalue" where [keyfield]
   is the unique key identifying the record shown on form 1 and keyvalue
   its value on form 1.

   This way you would simulate a sort of form/subform behavour on two
   independent forms. Of course whenever you change the record on form 1
   you may need to requery the second form to keep in pace.


   Theo
1624.3I got itROCCER::JHAThu Jan 30 1997 07:427
Ref: .1 & .2

Yes, It works.
Thank you for your help.

John