Filtering a record based on a check box

Please forgive my newbieness...

I have a form that displays a number of records.
Each record includes a number of fields including a yes/no for check box data entry.
I wish to check the box update the yes no field and extract a value from a different field in that row.

I have been working with GoTORecord, SetValue, RunSQL but not having much luck can anyone help?

Thanks




Comments

  • : Please forgive my newbieness...
    :
    : I have a form that displays a number of records.
    : Each record includes a number of fields including a yes/no for check box data entry.
    : I wish to check the box update the yes no field and extract a value from a different field in that row.
    :
    : I have been working with GoTORecord, SetValue, RunSQL but not having much luck can anyone help?
    :
    : Thanks
    :
    Hi Juan,
    Use the "AfterUpdate" Event on the CheckBox control that is used for your yes/no field. When you check or uncheck the control the underlying field in the database will be updated, this will fire the event, you can then get the value of the field that you want.
    It will look something like:-
    [CODE]
    Private Sub CheckBox1_AfterUpdate()
    Dim myVariable
    myVariable = Me.NameOfField
    'Do what you want with the data
    End Sub
    [/CODE]

    :
    :

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion