modify record with a button and a not null check

A

Andacami

Hi,

I have been playing with the Issue log sample databse from the Office
Downloads pages. What I want to do is add a button called "Close" on the main
form that changes the status field in the issues table to closed. The values
in this filed are Open, Suspended and Closed.

I can change it by using the drop down but I want a button. Additionally I
want the command to check that two pages in a tabed area on the form, closure
detail and fix detail, are not null before it will set the status field to
Closed.

If there are any examples out there that I can learn from all the better,
thanks.
 
M

mscertified

If you don't want the field displayed, add a control to the form with visible
property set to FALSE and bind it to the Status column.
In your click event for the button set this hidden control to 'closed'
You can also include any validations in this event before you set the value.

-Dorian
 
Top