Change in "yes/no" field in database

[osp001]

I need some help in doing a one-time-only inventory change to my database.

I'd like to create a form that, when a given number is entered, a field with a "yes/no" data type associated with it is changed from "no" to "yes." In other words, when number "1234" (container:table_containers) is entered, another column in that row (present:table_containers) is changed from "no" to "yes."

1233 no
1234 no
1235 no

And entering "1234" into the form changes the table contents to:

1233 no
1234 yes
1235 no

Could anyone suggest how I might do this? I'd appreciate the help. Thanks!

 

[willir]

You can use an Event Procedure to do this on a form.

For example,
AfterUpdate for the control (i.e., text, list or combo box), you can set the boolean value to yes. Other possible event procedures to consider may be BeforeUpdate the record and the OnCurrent record event.

What I am not sure about is how you retrieve your data, or what action you are doing when you want to change the boolean value to yes.

For example, let's say you retrieve a record using a combo box. The AfterUpdate event for the combo box retrieves the selected record and then sets the yes/no boolean field to yes.

Assumptions:
cmbSelectID - is the combo box, and accepts a numeric value
YourID - the primary key for the record, and a control on the form uses the same name

If Nz(Me.cmbSelectID, 0) Then
   Me.Filter = "YourID = " & Me.cmbSelectID
   Me.FilterOn = True
   Me.YourYesNo = Yes
End If

Richard