Listbox - Change underlying field value.

  • Thread starter Thread starter Robin
  • Start date Start date
R

Robin

Hello,

I have two listboxes for assignments. First listbox (Current) contains all
current assignments and the second listbox (New) holds recently assigned
items until staff "accepts" then by highlighting the listbox item and
clicking a button. The query criteria for the "New" listbox filters
assignments on a Yes/No field set to true. The "Current" listbox query
filters assignments on the Yes/No field set to false. When the button is
clicked on a New assignment, I would like that field to be set to false and
requery both listboxes so that the assignment "moves" from New to Current.
Any ideas?
 
Thank you Rob,

That's it. One quick glance at article 71 told me I was thinking about it
the wrong way. Rather than trying to get VBA to update a field in a table,
simply use an appropriate query with criteria set to the value of my listbox
to change the value. Sometimes I overthink these things!

Thanks again,
Robin
 
Back
Top