Fill in data into table upon "on click"

[teekc]

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?

[Bob Fitz]

If I click on Button Print, I want its correspond Return Date set to zero, Availabilty set to 0.

Do you really want set the date field to zero, or set it to Null.

[teekc]

Do you really want set the date field to zero, or set it to Null.

set it to as i never entered anything, null that's it?

[trevor40]

try this...

Button_Ack_Click()
me.[return date] = date()
me.availability = 1
End Sub

Button_Print_Click()
me.[return date] = Null
me.availability = 0
End Sub

[teekc]

yes, done, worked, thank you a lot, i am VB zero, so i have to spent sometime learning