Disappearing subform

Question

I have a form containing a sub-form. The linked fields are two: FW (fiscal week) and payno. The sub-form is populated by a query which has some calculated fields (scale * hours for example). When I populate the FW and Payno fields on the main form, the sub-form disappears after about a second or two. I can continue typing in the hours (regular and overtime on the main form) but it never reappears. If I look at the main form in design view and then back to form view, the sub-form is visible and the calculations were performed. Any idea why this sub-form disappears?

Answer 1

no I haven't. I have other forms w/sub-forms in the same database and they work fine. I've tried duplicating the properties but that doesn't work either

Answer 2

A subform will disappear - just be a blank rectangle with the form background color - if two things are true: 1. the subform has no records to display and 2. it's not updateable  or doesn't allow additions (so you can't see the blank "new record"). Might this be the case? Perhaps you could post the SQL of the subform's Recordsource query.

Answer 3

Denny

I don't see that as something that would hide the sub. Have you tested this on another computer?

Answer 4

no sir, but I have a macro that takes me to the first field in the details section after inputting the payno. The reason is because I put the two key fields in the header. Tabbing won't get me from the header section to the details section. The macro is probably a GOTOCONTROL.

I say "probably" because I'm at home now and don't have it in front of me. I will look at this again tomorrow at work.

Answer 5

Do you have any code behind the main form that might be hiding the sub?