field from subform to appear in a textbox on the form

  • Thread starter Thread starter postman
  • Start date Start date
P

postman

Getting field from subform (datasheet) to appear in a textbox on the form.

I have a comments field with several lines of text, so its not practical to
have it shown in datasheet view on my form. I want the comments field to
appear in a text box below the datasheet subform.

But the textbox's control source =[comments] reads the "first" record's
comment field even when I move down to another record in the subform
datasheet, when it should read the new records comment field.

I have tried placing a textbox in the subform, & directing the form textbox
to it, but still not work.

Any ideas...

Thanks.
 
if i understand you correctly, the unbound textbox (that shows comments from
the subform's current record) is in the main form. try putting a requery
command in the subform's Current event procedure, as

Me.Parent!MyTextbox.Requery

hth
 
Back
Top