I have a Multiselect Listbox (listScanned) that shows records from a Table (TempDelivery). The Column shown in the ListBox is named ParcelID.

I have a Multiselect Listbox (listScanned) that shows records from a Table (TempDelivery). The Column shown in the ListBox is named ParcelID.

I have a Multiselect Listbox (listScanned) that shows records from a Table (TempDelivery). The Column shown in the ListBox is named ParcelID.

I am trying to create a form with multiple list boxes to allow the user to filter the results. Here is my code for the button called ‘Query’:

This is all about bill of materials on parts.. The problem I’ve hit is when a child part has its own bill of materials I need to transfer it to the top level part

I’m trying to insert 3 fields into a table, Tbl_BOM_Requirments.

In MS-Access, I have a main table looking like below:

I have set DIM k as recordset and I have set DIM kk as field. I set k = as table “keywords” and I set kk to the field “key”. I now want to loop through table k and compare each record of field kk to my SQL string. I keep getting an Object Required error 424. I thought I have defined all my objects. Here is code and image.

SQL tests fine outside the loop, not in the loop. Table c has 4 comments in the “CMT” field. Table k has a list of 2 keywords in the “KEY” field. The loop tests each of the comments for existence of the keyword then if exists, stores the Refnum and keyword in Table Mariners. The Do Until c.EOF loops through each comment. The For Each loops through each of the keywords “kk” in the Keywords table. The SQL should UPDATE the mariner table WHERE the comment (long field) contains the keyword (using LIKE). Without the two loops, the SQL statement works fine (using fixed word vs. variable). The error says Sub or Function not defined and highlights MOVENEXT. My MoveNext moves through each of the comments and is placed just before the LOOP. What am I missing. This is the last obstacle I am running into. Image of error attached, and code below.

So I have the below code that runs fine in VBA application on a button click, however when I go to rerun it after changing values of certain fields. The code stops on Me.PCN with the following error.