A Subform that is Not strictly a subform but behaves like one?!!

[manix]

Hi All,

I have tried searching for this but I don't really know what to look for. I have A main table that is populated by a form. I then have another table that collects data and is related the main table by a common field (a One to Many relationship).

I then have a separate form to complete the 2nd table which I want to behave like a sub form (I.e. each record relates to one another), but I do not have room on the main form, so it needs to be opened via a radio button.

How do I get this other form to behave like a subform would do if it was embedded in the main form?

Sorry if it seems confusing, I know what I need, just struggling to get there! I can draw a picture if required!

 

[wazz]

i think you want your second to pop up via a command button and you also want your second form to show the correct "many-side-data" when you move to different records on your main form. if that's correct, then you can place some code on your main form's On Current event to requery the second form.