Hi,
I've gotten much farther now but can't figure out how to specify the name of the table
still. In the following, the table name would be the buttons(x).caption name. But isn't
RowSource somehow the equivalent of a use table statement. In any event, I have flagged
the problem with &&xxxxxxxxxx

Thanks so much Steve Elster

mm = transform(thisform.OptionGroup1.Value) && the number of the option chosen
nn = mm
nn = val(nn)
oo = lower(alltrim(thisform.OptionGroup1.buttons(nn).caption))

&&xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
mytable = "c:" + oo + ".lcontact,fcontact" && problem defining table name??
&&xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

thisform.list1.RowSource = myTable
thisform.list1.RowSourceType = 6
thisform.list1.reQuery() && is this how to requery a ListBox