Main Form and Sub Form

  • Thread starter Thread starter Vina
  • Start date Start date
V

Vina

Hi!!
I have a main form that has a subform.
I have a command click that will open another form (
order entry)

Main form
Customer ID
Main Form Sub form
Ship ID

Order entry form I have these fields
Customer ID
Ship ID

I have entered in the Customer ID(order entry) the
default value is the Customer ID in the Main form but...

I cannot use the default value in my SHip ID(order entry)
= Ship ID in the form. How can i link these fields cause
it's coming from a subform.

Any ideas is appreciated.

Thanks
Vina
 
The easiest way is to add an expression to the default
value property of your order entry form (This will only
work if your other forms are open, otherwise you have to
use Visual Basic to set the value)
i.e.
NameofMainForm!NameOfSubForm!NameOfShipIDControl
 
Back
Top