Referring to an object in a subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear friends,

I need to refer to a value in a text box which belongs to a subform from
another form (not the parent form).
Can anyone help me?

Thanks
Catalin
 
Dear friends,

I need to refer to a value in a text box which belongs to a subform from
another form (not the parent form).
Can anyone help me?

Thanks
Catalin
Click to expand...

Try this:

Forms![NameOfYourMainForm]![NameOfYourSubForm].Form!
[NameOfControl].visible = true

The line above will make the referenced control visible.

Until you get the syntax down, here is a method that might help you to
get the statement correct.

Open a new query.

Place your cursor in the Criteria of any column.

Right click and select the "Build" option.

Use the options in the "Builder" to specify the form, the subform and
the control (you can in most cases even include the property you want
to modify) and paste your selections into the builder's text box.

Copy the entry to the clipboard.

Close the Builder and the new query.

Paste the line of code into your VBA code.

HTH

Mr B
 
Thanks a lot.
You've been very helpful.

Catalin

Mr. B said:
Dear friends,

I need to refer to a value in a text box which belongs to a subform from
another form (not the parent form).
Can anyone help me?

Thanks
Catalin
Click to expand...

Try this:

Forms![NameOfYourMainForm]![NameOfYourSubForm].Form!
[NameOfControl].visible = true

The line above will make the referenced control visible.

Until you get the syntax down, here is a method that might help you to
get the statement correct.

Open a new query.

Place your cursor in the Criteria of any column.

Right click and select the "Build" option.

Use the options in the "Builder" to specify the form, the subform and
the control (you can in most cases even include the property you want
to modify) and paste your selections into the builder's text box.

Copy the entry to the clipboard.

Close the Builder and the new query.

Paste the line of code into your VBA code.

HTH

Mr B
Click to expand...
 
Thanks a lot.
You've been very helpful.

Catalin



Try this:
Click to expand...
Forms![NameOfYourMainForm]![NameOfYourSubForm].Form!
[NameOfControl].visible = true
Click to expand...
The line above will make the referenced control visible.
Click to expand...
Until you get the syntax down, here is a method that might help you to
get the statement correct.
Click to expand...
Open a new query.
Click to expand...
Place your cursor in the Criteria of any column.
Click to expand...
Right click and select the "Build" option.
Click to expand...
Use the options in the "Builder" to specify the form, the subform and
the control (you can in most cases even include the property you want
to modify) and paste your selections into the builder's text box.
Click to expand...
Copy the entry to the clipboard.
Click to expand...
Close the Builder and the new query.
Click to expand...
Paste the line of code into your VBA code.

Mr B- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Your welcome. Glad to help.

Mr B
 
Back
Top