Multiple Records selected

  • Thread starter Thread starter Lisa Mullin
  • Start date Start date
L

Lisa Mullin

What is the best way to have a form open another form with
some (multiple records) of the information from the
previous details section carried over?

I have a staff list that is generate from a larger table
based on some criteria, and I can select 1 employee for
further processing, but I want to be able to select
multiple employees for the next form??

Thanks,

Lisa
 
Lisa,

One way to do this is add a new field to the main table, Yes/No data
type, which will be represented on your form by a checkbox. You can use
this to select the employees you want to work with, and make the
"further processing" form based on a query which uses a criteria based
on this field. You would need to use code or run an Update Query to set
the value of this field back to 0 for all records afterwards.
 
The checkbox would work if I could force a "commit" to the
database before calling the new form - it seems that
sometimes the checkmarks are captured and sometime they
are not - any ideas on how I make the changes stick before
I leave the form?

Lisa
 
The checkbox would work if I could force a "commit" to the
database before calling the new form - it seems that
sometimes the checkmarks are captured and sometime they
are not - any ideas on how I make the changes stick before
I leave the form?
Click to expand...

Put a line

DoCmd.RunCommand acCmdSaveRecord

in the code that opens the second form (before the OpenForm line).
 
Back
Top