Subform empty when main form loaded

[martyjward]

I have a mainform which contains two subforms

The first subform contains all records from a table and loads perfectly fine when the main form is opened

The second displays a subset of the same records based - a list of records for a selected company ID, this in contrast to the first subform appears blank when the main form opens.



I can manually populate the blank subform by pressing F5, adding a refresh button (uses me.reacalc) and by making the comany ID field a combox and using an after update event that refreshes the form.

I would like the empty subform to populate using the company ID selected when the form is opened (this comes from another form).

I have tried re-calculating the form using several events such as AfterUpdate - but can not get this subform to populate.

Can someone please give me some guidance?

[Bob Fitz]

Take a look a at this link

http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp

Please post back if you need more help