By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,463 Members | 774 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,463 IT Pros & Developers. It's quick & easy.

Shared form on network not retaining values?

P: n/a
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?

Aug 15 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Aug 15 '06 #2

P: n/a

"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?.
Aug 15 '06 #3

P: n/a
"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/
Aug 15 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.