Default form.field value based on value in another form

[rjmccafferty1]

In a date field in an Invoice form, the user enters a value. Then they move to a Line Item form which also has a date field.

How can I get the date field in the LIneItem form default to the entry in the Invoice.Date form-field?

The system is set so that the user makes entries in the Invoice form and then a button opens another form for the LineItem entries. Thus, when the LineItem form opens, the Invoice form will be open and a value will exist in the Date field which I want to be the default in the Date field of the LineItem form.

 

[PHV]

Set the DefaultValue property of the Date field of the LineItem form to something like this:
=Forms![Invoice form]![date control]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya rjmccafferty1 . . .

Its all a matter of form referencing. Have a look at Refer to Form and Subform properties and controls

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]