Hey, I'm getting hung up on this and it's getting a little bit frustrating...
I have a form with a list box (lstTookCourse) that is populated by a query. (the populating query works fine)
The listbox has 3 columns, a personnelID (number field and an auto-number PK for the personnelID table), a last name, and a
I want to be able to run an UPDATE or an INSERT statement on a different table, but this depends upon whether a record
already exists (then do update) or if I need a new record (then do INSERT)
Anyway, the table in question has two fields, which act as a joint primary key.
One of the PKs I can get from a combo box somewhere else on the form.
The problem is getting the value of the other PK, which is the first column in the list box.
To loop through the selected items in the listbox I use the code:
Dim item As Variant
For Each item In lstTookCourse.ItemsSelected
I can reference the value I need with:
The problem is, I don't know how to reference this number in the WHERE clause of a query that I call within the loop.
So, my question is: how do I reference the number in the WHERE clause of a query that I call from within the for loop?
I tried [Forms]![Form Name]![lstTookCourse].[column(0, item)]
But obviously, that doesn't work.
I also tried the list boxes .value method, but had no luck with that either.
Sorry if I went rambling on a bit, but I wanted to give as complete a picture as possible.
Thank you in advance.