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)
<\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.

Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.