Selection Box Woes

[shadowspell]

After the fact, I was asked to create a selection box for a field "Posting Type" rather than have the user check a box to indicate a "Posting" is to take place.

I would like to run a query that would the check the "Posting" checkboxes and if the box is checked, autopopulate the selection box field with one of the values in it.

I'm thinking I need to run a change query, that would check the value of the checkbox, "=(Abs([Posting])) >0" and do a 'change to' to the "Posting Type" selection box field.

Am I on the right track here?
Thanks,
Chris

 

[Jack Cowley]

I don't quite understand what is is that you need to change because a checkbox is either true or false. That means that your 'selection box' (I am not sure what you mean by a 'selection box') can only have one of two possible answers. With your current form you can hide the check box and use code to display something in an unbound text box on the form. If, for example, you want a text box to say 'Posted' if the check box is true you can do that with code similar to this in the forms On Current event:

If Me.CheckboxName = True Then
Me.UnboundTextBox = "Posted"
Else
Me.UnboundTextBox = "Not Posted"
End If

hth,
Jack