P
Paul Hammond
I have 8 text boxes on frmMain which use formulas to populate,
e.g. =DFirst("FROMDATE","DrawCurrent") These formulas are retrieving data
from linked tables.
The first text box always shows #Error when the form opens, but all the
others populate correctly. If I close the form and reopen it, the error
disappears. My theory is the text box tries to read the table before the
link is established, but that's just a guess.
Any ideas on how to resolve this without closing and reopening the form?
TIA
Paul
--
e.g. =DFirst("FROMDATE","DrawCurrent") These formulas are retrieving data
from linked tables.
The first text box always shows #Error when the form opens, but all the
others populate correctly. If I close the form and reopen it, the error
disappears. My theory is the text box tries to read the table before the
link is established, but that's just a guess.
Any ideas on how to resolve this without closing and reopening the form?
TIA
Paul
--