sub form prints blank

Topic

New Reply

Just experienced a weird one in Access 2000 using Win 2000. Unbound main form with no controls at all except for 4 sub forms (not nested).
The 4th sub form used to be bound to a query, but it took 3 minutes to calculate &/or re-query. I altered the sub form to unbound and used Dlookups as recordsources for all text boxes (same query), result

Reply | Quote

Replies

If the main form is unbound, what criteria are you using for the dlookups? For that matter, what is it looking up when you run it as a main form?

Reply | Quote

Thanks for your interest.
sample of filling one control from the form OnOpen event
NumWks = DSum(“[Wks]”, “qryClSize3a”)
BSize = DFirst(“[SumOFNum]”, “qryClSize3b”, “[Class]=’B'”)
Me![txtMeanB] = Round(BSize / NumWks, 1).
But my main query is not why it took so long to calculate, (although I would REALLY like to know why), but why the controls print blank.

Reply | Quote