Show record on the main form related on the sub form.

[Guest]

Hello
please help me.
I want a main form and sub form that related with a same field. Each record
on the main form, have the several record on the sub form. I want see that
record on the main form by clicking the related recrord on the sub form.
Example:
Main form feilds: StuffName , StuffModel , ... (One StuffModel)
Subform fields: StuffModel , TotalInStock, StockLimit , ... (Several
StuffModel)
Related feild: StuffName

Thanks
Amir_J

 

[Jeff Boyce]

I'm a bit confused. From you description, it sounds like [StuffModel] is
the common field between main form and sub-form. And it sounds like your
main form displays information related to [StuffName], so how would you see
having it also display a specific [StuffModel]'s information?

Another approach might be to use a tab control on a main form, and within
one of the tabs have a subform than displays information about a chosen
[StuffModel]...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Guest]

[StuffName] is a field of sub-form also, but dont show on the sub-form.
sub-form record source is from a query.

I'm a bit confused. From you description, it sounds like [StuffModel] is
the common field between main form and sub-form. And it sounds like your
main form displays information related to [StuffName], so how would you see
having it also display a specific [StuffModel]'s information?

Another approach might be to use a tab control on a main form, and within
one of the tabs have a subform than displays information about a chosen
[StuffModel]...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Hello
please help me.
I want a main form and sub form that related with a same field. Each record
on the main form, have the several record on the sub form. I want see that
record on the main form by clicking the related recrord on the sub form.
Example:
Main form feilds: StuffName , StuffModel , ... (One StuffModel)
Subform fields: StuffModel , TotalInStock, StockLimit , ... (Several
StuffModel)
Related feild: StuffName

Thanks
Amir_J