Displaying data on a from from another form or table

C

Colin

Hi all,

Been trying to setup a form which can be used as an input
form to produce an order.

The form is set to continuous forms (so I can't use a
subform for this problem) for the data but with the field
titles in the form header along with a small calculation
which keeps a running total of the complete order.

Also in the form header I wish to display display the
contents of a field from another table which will be a
unique order number inputted by the user - the reason I'm
not putting this field in the Record Source of the form is
that the user should only have to input this once for the
whole order and not on every line (record).

Is there any way I can do this?

Many thanks for any help,

Colin.
 
Top