Re-reformatted for clarity (lol)
>Hey Steve,
>
>Reformatted for clarity :-)
>
>Anyway, yeah, I have an idea: If both Forms use the same datasession (probably Default) and you have explicitly opened "attempts" in the second form's DE, when you close the second form it's closing the table so it no longer is open in the first form.
>
>---------------
>I have two forms, I have a listbox on the main form with the following code in the RowSource property and Fields for my RowSource Type:
>
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)
>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