Listbox - Change underlying field value.

[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?

 

[Rob Parker]

Hi Robin,

I notice that no-one has answered this yet. Here's a possible starting
point for you: http://www.helenfeddema.com/access.htm

In particular, have a look at articles 71 "Paired Single-Select Listboxes"
and 72 "Paired Multi-Select Listboxes".

HTH,

Rob

 

[Robin]

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