Referencing "non-bound" columns in a listbox

[Lance]

Hello,

I currently have a list box, which lists 4 fields from 1 table (uses 5
including autoID)

AutoID
Name (text)
Amount (number)
Date (date)
Paid (Yes/No)

Data is inserted into this listbox from a menu, that lets you select
the name, amount, and date.

I would like to be able to select an item in the listbox, and then
click a button that will toggle the "paid" field from no to yes.

My approach was to have the button run an update query, which depending
upon the record selected, would check the Paid field, and then update
it to the opposite (so if yes, then query runs no, if no, then query
runs yes).

However, I cannot figure out how to pull the value from the listbox for
the paid field, to check this?

Any ideas?

Thanks,

lance

 

[Rick Brandt]

Hello,

I currently have a list box, which lists 4 fields from 1 table (uses 5
including autoID)

AutoID
Name (text)
Amount (number)
Date (date)
Paid (Yes/No)

Data is inserted into this listbox from a menu, that lets you select
the name, amount, and date.

I would like to be able to select an item in the listbox, and then
click a button that will toggle the "paid" field from no to yes.

My approach was to have the button run an update query, which
depending upon the record selected, would check the Paid field, and
then update it to the opposite (so if yes, then query runs no, if no,
then query runs yes).

However, I cannot figure out how to pull the value from the listbox
for the paid field, to check this?

Any ideas?

Me!NameOfListBox.Column(4)

The column numbers start with zero.

 

[Lance]

Thanks, That did the trick.