Subform field in VBA

[abidshahzad4u]

Hi

I have a form and subform. Subform fields are populated by a tree view control on the main form.

I want to access the subform field in VBA.

How can I do that?

regards

 

[JANR]

see if this help: http://www.mvps.org/access/forms/frm0031.htm

JR

 

[abidshahzad4u]

Thanks for the reply.

Actual situation is as:
When I want to delete the record from subform using delete button present on the subform. Before deleting I want to check that the record itself has some child record. If yes, then the record can't be deleted, until child records exist.

I am using the following
Me.txtPatent.Value
in sql query.

But no value is taken from the text box.