M
Mercy
Hello,
I have a form OrderForm with Subform X, which pulls it's
records from:
Select product
From Fabric
Where Fabric.Marked = No
OrderForm has a command button on it which will change
the record source that the SubformX relies. Mainly it
changes the cooresponding records in Fabric to be
Fabric.Marked = Yes.
Now ... as long as I don't try to edit OrderForm ... I
won't lose the data in the Subform. But the data in the
Subform will be reset to BLANK if I try to edit the
OrderForm.
So ... is there a Form property I can set to make
OrderForm un-changeable after the cmd button is pressed?
Or perhaps someway to archive the record so I can access
it later for reference or to be printed out?
Thanks for any input,
Mercy
I have a form OrderForm with Subform X, which pulls it's
records from:
Select product
From Fabric
Where Fabric.Marked = No
OrderForm has a command button on it which will change
the record source that the SubformX relies. Mainly it
changes the cooresponding records in Fabric to be
Fabric.Marked = Yes.
Now ... as long as I don't try to edit OrderForm ... I
won't lose the data in the Subform. But the data in the
Subform will be reset to BLANK if I try to edit the
OrderForm.
So ... is there a Form property I can set to make
OrderForm un-changeable after the cmd button is pressed?
Or perhaps someway to archive the record so I can access
it later for reference or to be printed out?
Thanks for any input,
Mercy