IIF(attempts.EXT="YES",;
alltrim(str(attempts.seqno))+" "+;
attempts.placed+" via "+ATTEMPTS.ROUTE+;
" Extubated - "+ attempts.ext_reas,;
alltrim(str(attempts.seqno))+" " +attempts.placed+" via "+attempts.ROUTE)
<\pre>
What happens is, I get the error "Cannot access selected table" when I leave the form that contains the listbox and return to the form. After I get this error my listbox disappears from the form so I am quite sure Attempts table is being not being selected and that's when error occurs.
Any ideas? Thanks.------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05