>>I hardcoded the dbf for testing:
>>"thisform.mylistbox2.rowsource= "office97" "
>>The error I get is "field phrase is not found"
>>I'm sure I'm doing something stupid.
>
>It means that you typed 'phrase' somewhere in listbox property sheet. Find the place and clean it.
Damn, I have this in the cmdbutton
With Thisform.myListbox2
.RowSourceType=2
.RowSource=""
thisform.mylistbox2.rowsource= "office7" &&'offyear'
.Requery
Endwith
and still "field phrase is not found"
There is NO reference to the word phrase. Think I'm doomed?
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."