Click on table record show same record in text box.

[zorro19s]

I have few text boxes and a subform with a table in it. They both are the same database. I want to click on a record in the subform table and making same record appear in the text boxes above.

 

[jfischer]

A little more information about your forms and tables would be helpful.

If you only want to "display" information from the subform table in text boxes on the main form, you can add the necessary code to the OnCurrent event of the subform. For example:

Private Sub Form_Current()
  Parent!Text1 = Me!Text2
  ' etc.
End Sub

If you want to do more than that, say, do a record lookup for the main form, you'll need to be more specific about your forms, your tables, and the process you're trying to accomplish.