The background
I have a Table and a Form. I used the Form to key in data into my Table.
My Table has Name, Return Date, Borrow Date, Availability(1/0)
My Form only shows Name and Borrow Date for user to enter.
My concern
At the end, there are two buttons, Button Ack and Button Print.
Whenever I enter the name and borrow date, i am give a choice of either clicking Button Ack or Button Print.
If I click on Button Ack, I want its correspond Return Date set to today, Availability set to 1.
If I click on Button Print, I want its correspond Return Date set to zero, Availabilty set to 0.
Help? Please?