Help with Creating an event

[amdefeo]

Hello,



I have been working on a solution to this issue I am dealing with and can not figure it out, so I am hoping to get some help.

Here is the situation:

I have items on a contract price with an option if I decide to pick up the option the price increases $4 for one year. (pricing by the year)
I have my item set up with a Y/N check box to indicate if I have chose an option on that item(I dont pick options on all items), I also have contract end date on a field in the Item Ledger Table. I have a query set up to run and see what items are on option that the contract is expiring on.

What I would like to do is have in the query is another check box that says "Contract Picked Up" if I check this box the event need to update the following:

Price +4 (increase 4$)
Contract End Date + 1 (year)
Remove the Option check mark from the option Y/N (I cony only pick up the option once, meaning if I pick up the option in 2012 I can not do so in 2013)

Im not sure how to go about this...Do I do this "pick up option" Y/N in a query or form? And how would I build this "event" to update the Pice, Contract end date and remove the option check and make it (N)

Thanks.

[John_G]

Hi -

Querys do not have events, so you cannot solve your problem that way. Neither can you include in a query a checkbox (or any field) that you want to update, but which is not bound to a table field.

You will have to use a form and include that additional checkbox. However, that checkbox will have to be bound to a table field. Your changes could be done in the after update event of the new checkbox. But a note of caution - make the provision for what to do if you check the box, then change your mind and uncheck it again!

HTH

John

[amdefeo]

Ok thanks for the advice, and good call on the double check.

Will all of this have to be written in VB? And is there any references to the type of code I will have to write? Im not very good at code, so any additional info would be very helpful.