[AccessD] Access form and report anomalies

Sorry for the delay in replying.

In answer to your questions:
    * yes, each form has a subform that just reports on extra data. The 
user can't add any data to them.
    * The combo sits above the tab form.
    * Is it possible to set the recordsource to a tab sheet. I set the 
recordsource to the whole form.
    * I'm not sure what you mean by your suggestion.
    * The same result happens no matter what computer I am using.
At 11:02 31/07/2003 -0400, you wrote:
>Maybe I'd have to see the form to understand your request better. Do you
>have a subform on each of two tab pages? Does the combo sit on a tab page or
>above it in the form header? Or alternatively does the selected record
>source populate both tab pages? What about creating an additional hidden
>field and pointing each record set at its own hidden field? You'd have to
>modify one query slightly but that way the confusion might be eliminated.
>
>On the reports issue, is there a chance that the printer is set up for 3
>copies?
>
>Hth,
>Arthur
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David & Joanne
>Gould
>Sent: July 31, 2003 8:57 AM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Access form and report anomalies
>
>
>I have found two confusing problems with a database I am writing.
>
>1. I have a tab form where the record source is decided from a combo box.
>The record sources are both queries that are changed depending which tab is
>picked. both queries rely on a record number in a hidden field. If I leave
>the data in this field as is when changing record sources the form works
>perfectly except that the data on the chosen tab form uses the record
>number from the other form to display its data. I tried to clear the data
>in this field so that each time a form opens it opens clean. but I kept
>getting the message that I was changing the record  source and the form
>would crash. This only happened to the second of the form tabs while the
>first still kept working fine. Does anyone have any ideas what may be
>causing this.
>
>2. I have four similar reports that for some reason print in triplicate
>everytime they are run. This results whenever these reports are run, even
>if they are just previewed. Other than this hiccup the reports work
>perfectly. I hope someone can help me out of my confusion and to solve this
>anomaly.
>
>TIA
>
>David
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com