Nick,

You have a typo in your rowsource. I ran this code on a push button and it worked fine:

ThisForm.lstTest.rowsourcetype = 6
ThisForm.lstTest.rowsource = 'lvClubView.clubname'

REQUERY('lvclubview')
ThisForm.lstTest.refresh()

However, when I had rowsource = 'lvClubView.Clubs' I got the same error you reported (clubs is not a field in lvClubView.

Rob