Re: Help writing multi select list box selections to table

On Thu, 29 Mar 2007 15:40:06 GMT, "mystif via AccessMonster.com" <u32202@uwe>
wrote:

Can anyone see any obvious mistakes I have made here? I receive an error
message when the code runs NO CURRENT RECORD. (Code below)

That would suggest that the recordset you're opening returns no records. Are
[SprayOrderNumber] and [Block] Number fields (as the code expects) or Text?

Try setting a "breakpoint" in the code. Open the VBA editor on the routine,
and click in the grey vertical bar to the left of the code window next to some
executable statement - the line

Set db = CurrentDb

for example. A brown/red circle will appear. When you click the button, the
execution will stop at this line; you can press F8 to step through the code
line by line; hover the mouse over a variable to see its value; or type (e.g.)
?lngCondition

in the Immediate window to see its value. Without knowing more about the
structure of your tables, how your listbox is set up, etc. it's hard to guess
what might be going wrong!

John W. Vinson [MVP]
.