Split/Sub Forms

[khurram7x]

I'm trying to use sub-forms in split-forms mode, where main form displays one record and sub-form displays all the relevant records same exactly as in case of split-forms, but sub-form displays only one record.

What should i do to bring the split-forms type functionality in sub-forms?? i've linked the main form with sub form using tag number value.
I'm not using split-forms itself because it doesn't listen to size coordinates and always appears big and often bigger than the screen coordinates when i set pop up property to yes.

Thanks

 

[Galaxiom]

Both forms are implemented as subforms on the main form.

A textbox on the main form has a control source referring to the field on the datasheet (or Continuous) form that would normally be the LinkMasterFields in a typical master/child subform structure.

The LinkMasterFields on the subformcontrol holding the SingleForm is set to refer to the textbox on the main form. The LinkChildFields is as usual.

BTW Although it is possible to refer the single subform's LinkMasterFields directly to the field on the datasheet form it isn't always reliable because it depends on the load order of the subforms. The textbox makes it work reliably.

 

[khurram7x]

Both forms are implemented as subforms on the main form.

Thanks for the reply, but I'm kindof confused!!
When I implement both form as sub-forms and try Link Master or Link Child field, i receive error as "couldn't build a link between unbound forms". Is there a special way putting both forms as sub-forms to get rid of error please??

A textbox on the main form has a control source referring to the field on the datasheet (or Continuous) form that would normally be the LinkMasterFields in a typical master/child subform structure.

The LinkMasterFields on the subformcontrol holding the SingleForm is set to refer to the textbox on the main form. The LinkChildFields is as usual.

To clarify myself, are LinkMasterFields and LinkChildFields are common keys in their respective tables... in my case TagNumber??

BTW Although it is possible to refer the single subform's LinkMasterFields directly to the field on the datasheet form....

I'm using datasheet as sub-form. Are you talking in reference to first statement, i.e. both forms are implemented as sub-forms? If this is the case, it is not working for me as i explained earlier. But if you mean datasheet as main form here, then it is not working for me either because subform datasheet displays only single record, while i want subforms to display all records as in case of split forms.

I'm apologize for not understanding you well enough!

Thanks

 

[RainLover]

Are all data types the same.

You can't link Text to number and so on.

Try removing the links to see what happens. You should have 3 forms with all data showing.

This may help you understand what is going on or on the other hand reveal nothing. But it is worth trying.

 

[Galaxiom]

Both forms can use the same RecordSource.

LinkFields are all set manually.
The datasheet subform has empty LinkFields properties. (If you are using the wizard select the option to set the linkfields yourself.)

The main form is entirely unbound. You cannot use a datasheet main form because it would not support a subform.