Is this possible in Access?

[Ayo]

I have a form with a subform some comboboxes and a textbox. What I want to do
is select a record in the subform and have the textbox display the content of
the comment field of the selected record. I know I have to use a function. I
have done something like this before except, in that case, it was to open
another form. I don't know what will go into this function.
Any help will be greatly appreciated.
Thank you

 

[aaron_kempf]

this would take zero coding if you were usign SQL Server Reporting
Services.

-Aaron

 

[Dirk Goldgar]

I have a form with a subform some comboboxes and a textbox. What I want to
do
is select a record in the subform and have the textbox display the content
of
the comment field of the selected record. I know I have to use a function.

You don't necessarily have to write a function. Does the subform have a
control that is bound to the Comment field? If not, can you add one? You
could make it invisible and give it a height and width of 0.

If your subform has such a field, then you could set the control source of
the text box (on the main form) to an expression that pulls the value of the
Comment field on the subform, like this:

=[SubformName]![Comment]

In the above, "SubformName" must be the name of the subform *control* on the
main form, which may or may not be the name of the form object being
displayed by that control.