On Tue, 15 Jul 2003 10:09:12 -0700, "Seddon Acaster"
<seddonandjulia@acas.demon.co.uk> wrote:
>Running Access 2000. One form contains all information
>for clients. The other form contains an invoice layout
>with certain fields from first form.
Clarification:

The Form doesn't contain any data, any more than the window of my
office contains the Owyhee Mountains. The Form DISPLAYS data which is
stored in a Table. You would generate your report from the Table, not
from the data in the Form.
>I want to click a
>command button from first form and send the current
>record data from that form to the invoice form and then
>print.
Create a Query based on the tables containing the data you want on the
invoice form, and either use the Form to provide criteria to specify
which record to print by using

=Forms![NameOfYourForm]![txtID]

as a criterion on the ID field (whatever that might be); or edit the
wizard-generated VBA code in the "Open Form" button to put the ID into
the WhereCondition argument. See the online help for OpenForm for an
example.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
[url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]