There has to be a better way to do this...

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

Hi there! Using A02 on XP. Have a mainform fCkReturnMain
and subform fCkReturnReasonSub. There is a comments field
on my main form. The subform has 6 checkboxes to select
one or more reasons to return the check. If I check a box,
I have wordage to add to [fCkReturnMain ].[Comments].

To accomplish this in the past I have created
visible.false textboxes that 'read' the data from the
subform onto the main form (for example:
=[fCkReturnReasonSub].[NoFormat]) and when each one is
updated, wordage is appended to [Comments].

Is there a way to have this happen without having to
create all the invisible textboxes?

Thanks in advance for any help or advice!!! LUV U GUYS!
 
Bonnie,
I would have a 6 option OptionGroup in my subform that would yield a
value from 1 to 6. (If you use 6 T/F fields, then you'll have to
interrogate each one...)

Then in my subform code... this is "aircode" intended as a verbal
guide... you work out the exact synatx, and use your own fieldnames...
If MyOptGrp = 1 Then
Forms!frmMyMainForm!Comments = Forms!frmMyMainForm!Comments &
"Insufficient Funds"
If MyOptGrp = 2 Then
Forms!frmMyMainForm!Comments = Forms!frmMyMainForm!Comments &
"No Endorsement"
Etc... for all options
hth
Al Camp
 
Thank you Al!!! Really appreciate the info and the advice!
I'll do the option group route and try the code. Thx!
-----Original Message-----
Bonnie,
I would have a 6 option OptionGroup in my subform that would yield a
value from 1 to 6. (If you use 6 T/F fields, then you'll have to
interrogate each one...)

Then in my subform code... this is "aircode" intended as a verbal
guide... you work out the exact synatx, and use your own fieldnames...
If MyOptGrp = 1 Then
Forms!frmMyMainForm!Comments = Forms! frmMyMainForm!Comments &
"Insufficient Funds"
If MyOptGrp = 2 Then
Forms!frmMyMainForm!Comments = Forms! frmMyMainForm!Comments &
"No Endorsement"
Etc... for all options
hth
Al Camp

Hi there! Using A02 on XP. Have a mainform fCkReturnMain
and subform fCkReturnReasonSub. There is a comments field
on my main form. The subform has 6 checkboxes to select
one or more reasons to return the check. If I check a box,
I have wordage to add to [fCkReturnMain ].[Comments].

To accomplish this in the past I have created
visible.false textboxes that 'read' the data from the
subform onto the main form (for example:
=[fCkReturnReasonSub].[NoFormat]) and when each one is
updated, wordage is appended to [Comments].

Is there a way to have this happen without having to
create all the invisible textboxes?

Thanks in advance for any help or advice!!! LUV U GUYS!
Click to expand...


.
Click to expand...
 
Back
Top