Odd Form Behaviour! Advice needed and heeded.

[Hierophant]

Thanks for checking this out,
Basically, I have a form "Accountancy", which has the subforms
"Receipts", and "Expenses".. simple enough.

My subforms won't be populated with records when I open the form Accountancy be it in display(then changed to view mode) or from the Forms Tab directly, or from another Form.

BUT, once open, if I toggle it to Design view, then back again to Form view, hey presto, its working beautifully! My two subforms are populated with appropriate records.

Can anyone explain this phenomenon? It's kind of frustrating, since the code IS simple, as is my goal. I use Access XP.

Thanks in advance! Hope to hear from you soon,

Hiero.

 

[Autoeng]

I have the opposite! This happens on a form that I have as well when I change from form view to design view. The subforms display as white areas. I don't know why this happens but I just go back into Form view then back into design view and then it will be taken care of. I wish I could help you as your problem is much worse than mine but I haven't discovered the reason why.

 

[neileg]

When I get a wierd problem like this, first I try a compact and repair. Then I try opening a blank file and importing everything over (in theory this is the same as compact and repair). Only after these fail do I start getting creative!

 

[Autoeng]

Have done all of your suggestions previously to see if it helped my situation but it did not. It's like a little Access program glitch.

 

[Hierophant]

Yeah... thanks for the replies, but no help. My form allows additions...

Just to give you a bit more info, the subforms display records whose creation date fall between two dates specified on the Accountancy page. This probably has something to do with it I suppose... But I'm a novice, and have no idea what.


Furthermore, occasionally when I open it from the Form tab, I get two errors, saying that an expression is too numerically complex etc etc try to break it into variables etc etc. I get two of these, which makes me think the subforms are sus...

Anyone else got any ideas?