check box

[krzysiekk]

Its possible to update in field form status A to B using check box?? please advise

 

[John Big Booty]

Could you possibly explain step by step what it is you want to do, as this will greatly effect the method.

 

[krzysiekk]

right, in table I will be insert new record, default filed content for new entries will be 'A' then users using form will be allow record to confirm 'C' and pass to next stage in process, Now in table for one day will be showing about 10 orders and I want confirm - update status field using check box, unchecked box - status A checked status C. Its possible ?

 

[John Big Booty]

In the form's On Current event put something like;

If Me.Confirm = "C" Then
     Me.CheckBoxName = 0 [COLOR="SeaGreen"]'Check boxes return -1 or True when checked and 0 or False when un-checked[/COLOR]
Else
     Me.CheckBoxName = -1
End If

Then in your Check box's on click event put something like;

If Me.CheckBoxName = -1 Then
     Exit Sub [COLOR="SeaGreen"]'I have assumed that once you reach status complete "C" you would not want to revert to status "A"[/COLOR]
Else
     Me.Confirm = "C"
End If

The check box would be unbound.