Toggle Buttons for Update Query Criteria

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have a table, tblData, with fields [ID] and
[DateComplete]. I have a form, frmData, with unbound
textbox [text1]. I want to use an update query to update
the [DateComplete] for selected [ID]'s. What I picture is
having the form display the list of [ID] with toggle
buttons next to each record. I will enter the date I want
in [text1] and the update query will update for all
records with the toggle button selected. I can't figure
out how to make this work. I don't have much experience
with toggle buttons and would appreciate your help.
Thanks in advance,
Tom
 
Toggle Buttons are similar to check boxes. When selected they contain the
value True, when not selected they are False. Will the button be linekd to
a field, if not create a new field in your table with the Yes/No data type,
change the format to True/False and set the default to False. On your form,
set the source for the toggle button to this new field. Now, when you
select the toggle button, the field will become a True. Create your update
query so that [DateComplete] is updated to [text1] where [YesNoField] is
True.

Kelvin
 
Back
Top