Re: Update of tick box on clese

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks Jeff,

It's actually a form for printing of a bank deposit for qheques. I want it
to update the "Banked" check box so that once the cheques are deposited they
no longer show in the query. I've placed a button to preview the report and
once the report is printed I want to click on the "Close" button to close
everything off.

If I were to go back into the form, I don't want it to show the cheques just
printed onto the report, just the new ones not yet deposited.

The main form is called "frmCash" and it's sub form "frmBankDepositSub" The
sub form gets all it's info from "tblPayments" where the tick box "Banked"
is located. I'm not quite sure where the text you suggested would be placed.
Is it in the "OnClose" of the frmCash (main form)?

Thanks for your assistance. I'm very much a learner!



"Jeff Boyce" <JeffBoyce_IF@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ev%23q1gnIGHA.2900@xxxxxxxxxxxxxxxxxxxxxxx
> Scott
>
> Consider the BeforeUpdate event. Or are you saying you want to "reset"
> the
> form to display a checked box on the next (new) record? If so, use the
> AfterUpdate event.
>
> If the former, you are changing the value before updating the record --
> use
> something like:
> Me!chkYourCheckBox = True
> in the BeforeUpdate event.
>
> If the latter, use something like:
> Me!chkYourCheckBox.DefaultValue = True
> in the AfterUpdate event.
>
> --
> Regards
>
> Jeff Boyce
> <Office/Access MVP>
>
> "Scott" <scott.spam@xxxxxxxxx> wrote in message
> news:43d8bab8$0$18584$5a62ac22@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> I Have a sub form with a "Yes/No" tickbox that I want to automatically
>> update to "Ticked" on the exit of the main form. I'd appreciate a hand if
>> someone has a free second. I don't know where to start looking for this
> one!
>>
>>
>


.

Relevant Pages

  • Code examples
    ... I have the need to produce a Bank deposit report for cheques and cash. ...
    (comp.databases.ms-access)
  • Re: lost deposit (forfeited deposit)
    ... See also, Son v. CIR, BTA Memo 1939-331 (deduction for loss on ... As to the treatment of the seller who retained your deposit, yes, it ... you, as payor, report the payment to the seller, although it might be ... only to have the buyer renege, my realtor convinced me that the wise thing to do was ...
    (misc.taxes)
  • Re: Australia: questions
    ... Once we tell the ATM we will be making a deposit it extrudes an envelope into which we have to insert our chequeand cash before allowing the ATM to gobble them up. ... I write very few cheques myself and they are usually to individuals or businesses who don't like to give out their account details for people to deposit directly into their accounts. ...
    (alt.usage.english)
  • Re: Australia: questions
    ... Once we tell the ATM we will be making a deposit it extrudes an envelope into which we have to insert our chequeand cash before allowing the ATM to gobble them up. ... I write very few cheques myself and they are usually to individuals or businesses who don't like to give out their account details for people to deposit directly into their accounts. ...
    (alt.usage.english)
  • Re: Bank security
    ... the U.S. must report any single cash transaction over $10,000 (deposit, ... generate the info if requested) of cash purchases - money orders, ... >>Pretty much any deposit at or over $1,000 is reported. ...
    (comp.security.misc)