This subform's got me stumped...

[jbfraleigh]

I have a form with two subforms. One of the two subforms works perfectly. The other just gives me a grey screen (like there's no recordset).

The two forms are very similar and I've checked everything I can think of... Here's what I've done. If you can think of anything else to try, please let me know - This is driving me crazy!

1) The subform works independent of its parent
2) The source object for the subform is set properly
3) The child and master fields are set properly. Data types are the same.
4) The record source for the form (used as subform) is set to the correct query.
5) The query used has been run independently with no problems
6) The form has a bound text box with the proper control source
7) I've tried placing a breakpoint at the first line of form_current.. never gets hit.

I don't know why it's not working and there's nothing that tells me what/where the problem is. I'm out of ideas on this one.... Any help is greatly appreciated!

 

[pbaldy]

Unless I'm misunderstanding, 1 & 3 seem to be in conflict with each other. If the subform is independent from the main form then you wouldn't need or want master/child links.

 

[jbfraleigh]

Good point - What I mean when I say that the subform works independently is that if I open it as a regular form, all the unbound items are displayed and it waits for an event - there are no runtime errors.

The point of this test (in my mind) is to make sure that there are no errors on the form that are preventing the main form from loading it as a subform.

I still haven't resolved this, so if anyone has any ideas or any tests that I can perform, please let me know.

Thanks

 

[pbaldy]

Only thing that comes to mind right off is that something (perhaps in the query) refers to the form, and when it's used as a subform the reference is invalid. Can you post a sample db?