Recent content by GrandadsReturn

Ok - thanks - lesson for me - thought there maybe a difference between the two constructs. Why didn't I ever do a computer science course? :(

Yes - I saw that - the difference is that you can use the MoveFirst method directly on the ListBox recordset. As the list box (called "LP") is on a form with the command button, I used Me.LP.Recordset.MoveFirst which fixed Spectrum's issue that I had replicated exactly. Have you tried it?

Thanks for the welcome :) A fix follows: The recordset is held in memory while the form is open - after first time the "CopyFromRecordset" method is fired, the cursor will be positioned at the end of the recordset. To reposition the cursor, add the following line of code before the...

Hi - I've just joined so can't post links yet but have a look at support dot microsoft dot com/kb/178510 The way you reference the Range in the Worksheet uses a different syntax to the example in the link and you don't mention an error being raised but - in case it helps...