Shared form on network not retaining values?

[Nick Douglas]

I have an unbound form to generate reports from in an mdb that we share
on our network drive. The users selects several options for the report,
such as what to view, the sort order, etc. These choices are then
stored in the tags of the controls. The report creation button reads
these values and outputs the desired report.

The problem is, when more than one person is in the db, the report
creation routine does not pick up the right values.

Is this because I'm using the tag property of controls to store values?
Should I use an invisible text box instead?

[Rick Brandt]

Nick Douglas wrote:

I have an unbound form to generate reports from in an mdb that we
share on our network drive. The users selects several options for the
report, such as what to view, the sort order, etc. These choices are
then stored in the tags of the controls. The report creation button
reads these values and outputs the desired report.

The problem is, when more than one person is in the db, the report
creation routine does not pick up the right values.

Is this because I'm using the tag property of controls to store
values? Should I use an invisible text box instead?

Why not use the controls themselves (the Value property)? And why would you
need to "save" anything? The form stays open when the user runs the report
right?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[paii, Ron]

"Nick Douglas" <ni*********@gmail.comwrote in message
news:11**********************@74g2000cwt.googlegro ups.com...

I have an unbound form to generate reports from in an mdb that we share
on our network drive. The users selects several options for the report,
such as what to view, the sort order, etc. These choices are then
stored in the tags of the controls. The report creation button reads
these values and outputs the desired report.

The problem is, when more than one person is in the db, the report
creation routine does not pick up the right values.

Is this because I'm using the tag property of controls to store values?
Should I use an invisible text box instead?

Are your users sharing the same front end, i.e. Forms/reports?.

[David W. Fenton]

"Nick Douglas" <ni*********@gmail.comwrote in
news:11**********************@74g2000cwt.googlegro ups.com:

I have an unbound form to generate reports from in an mdb that we
share on our network drive.

That's the problem. Don't share the front end.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/