Userform - pass textbox values to new Userform

OM1950

New member
Joined
Dec 12, 2014
Messages
3
Reaction score
0
Points
0
Location
Northern Queensland
I have 2 userforms – frmActionEntry, and frmActionClose. On occasions, when an action is being closed (frmActionClose) it may generate more actions (for instance closing an inspection as complete, but the inspection has found problems that must be added as new actions).
On my frmActionClose, I have a textbox that asks “Number of New Corrective Actions from this activity”. If this is not zero, then when the initial action is closed, frmActionEntry opens, for the input of the new actions.
All this works OK, but I want to link the new actions to the original action that generated them, by automatically populating several textboxes in frmActionEntry, with the values from frmActionClose - the values in txbNumber, txbSite, txbSection need to be passed from frmActionClose to frmActionEntry.
I can’t work out how to do this – can someone advise me please.
Thanks, OM1950
 
Hi OM1950,
What is the code you are using?
possibly something like
Code:
frmActionEntry.textboxes.value=  frmActionClose.textboxes.value
close frmActionClose
frmActionEntry.show
 
Hi OM1950,
What is the code you are using?
possibly something like
Code:
frmActionEntry.textboxes.value=  frmActionClose.textboxes.value
close frmActionClose
frmActionEntry.show

Thanks Pike - I'll try this now. It seems obvious now that you have supplied the above code, but I hadn't thought of reading the values directly, and it should work, because I'm only hiding (not unloading) the "parent" form.
 
Back
Top