Subforms

[Paul]

Hi, My question is about subforms.
I have 3 tables linked and shown in sub forms. If I click
on a record in the parent subform it shows all records in
the child form which is good. BUT what I want to see if I
click on a record in the parent form, a text box in that
same parent form the contens of a specific field.

For example.

Table column shows:
ID, partnumber, dimension, description.

I want to see the above mentioned labels in a subform
presented in dataformat BUT i would like to see the
description in a textbox because typing alot of tekst in a
dataformat enviroment is not very user friendly.

Any suggestions welcome.

Paul.

 

[John Vinson]

I want to see the above mentioned labels in a subform
presented in dataformat BUT i would like to see the
description in a textbox because typing alot of tekst in a
dataformat enviroment is not very user friendly.

You can open the form you're using in the Subform control and set its
Default View to "Continuous" instead of "Datasheet". This lets you
rearrange textboxes however you like.

 

[Paul]

I know that its possible but not my preference.
I woul dprefer a datafield and when clikcing a ceratin
record in that dataset that a tekstbox shows some
additional info associated with that record in the dataset.

 

[John Vinson]

I know that its possible but not my preference.
I woul dprefer a datafield and when clikcing a ceratin
record in that dataset that a tekstbox shows some
additional info associated with that record in the dataset.

Try setting the Control Source of a mainform textbox to

=subformname.Form![fieldname]

and requerying that textbox in the subform's Current event:

Parent!controlname.Requery