Using public variables with forms/reports/queries (1 Viewer)

Status
Not open for further replies.

DCrake

Remembered
Local time
Today, 10:59
Joined
Jun 8, 2005
Messages
8,632
Here is a sample database that uses public variables to pass between forms/queries/reports that each work independantly from each other. In other words one does not have to rely on the other being open to read the criteria settings.

I have also supplied a word document to support the demo by means of inrtroduction to its uses.

David
 

Attachments

  • PublicVariables.mdb
    232 KB · Views: 5,648
  • PassingPublicVariables.doc
    91 KB · Views: 7,277

buttons

New member
Local time
Today, 10:59
Joined
Aug 20, 2008
Messages
4
Hi David, many thanks worked a treat.

Could I ask a further "simple" question? I have created a button on my reporting form and have atempted to build some code behind it to Open the form to collect the data information and then to open the query and to export the results. However the code runs all the way through without stopping to allow the user to enter the dates!

I'm missing something to tell the code to stop and wait for the user to input the dates!.

Again any help would br gratefully received.

Buttons
 
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom