Using SubForms

[Guest]

I am using a sub form in my form. I need to know if there is a way to use
information on the subform to auto populate a field on the form? I have a
report name in the sub form, I want a validation question to populate on my
other form based on what the report name is.

Any help would be great appreciated.

Thank you

 

[Guest]

Use [Forms]![MainFormName]![SubFormName]![ObjectName]

Is the report name in a label or textbox? If it is the data in a text box
it will work but I do not think you can pull from a label.

 

[Guest]

Do I place this in the control source for the question that I want to have
automatically populate?

Use [Forms]![MainFormName]![SubFormName]![ObjectName]

Is the report name in a label or textbox? If it is the data in a text box
it will work but I do not think you can pull from a label.
--
KARL DEWEY
Build a little - Test a little

I am using a sub form in my form. I need to know if there is a way to use
information on the subform to auto populate a field on the form? I have a
report name in the sub form, I want a validation question to populate on my
other form based on what the report name is.

Any help would be great appreciated.

Thank you

 

[Guest]

You did not answer my questions.
--
KARL DEWEY
Build a little - Test a little

Do I place this in the control source for the question that I want to have
automatically populate?

Use [Forms]![MainFormName]![SubFormName]![ObjectName]

Is the report name in a label or textbox? If it is the data in a text box
it will work but I do not think you can pull from a label.
--
KARL DEWEY
Build a little - Test a little

I am using a sub form in my form. I need to know if there is a way to use
information on the subform to auto populate a field on the form? I have a
report name in the sub form, I want a validation question to populate on my
other form based on what the report name is.

Any help would be great appreciated.

Thank you

 

[Guest]

The report name is in a text box

You did not answer my questions.
--
KARL DEWEY
Build a little - Test a little

Do I place this in the control source for the question that I want to have
automatically populate?

Use [Forms]![MainFormName]![SubFormName]![ObjectName]

Is the report name in a label or textbox? If it is the data in a text box
it will work but I do not think you can pull from a label.
--
KARL DEWEY
Build a little - Test a little


:

I am using a sub form in my form. I need to know if there is a way to use
information on the subform to auto populate a field on the form? I have a
report name in the sub form, I want a validation question to populate on my
other form based on what the report name is.

Any help would be great appreciated.

Thank you

 

[Guest]

I have been making the following assumptions --
1 - Your main form gets it's data from a table, either directly or by way of
a query.
2 - Your subform is related to the main form in a Master/Child relation.
3 - The text box on the main form that you want to be populated is unbound
but will have a separate source than the main form source.

Call the unbound text box X-box. Use a select query that has the
[Forms]![MainFormName]![SubFormName]![ObjectName] as criteria. The query is
used as source for X-box.

Double-click on the field in the subform activaties an event or cals a macro
to refresh the select query.

--
KARL DEWEY
Build a little - Test a little

The report name is in a text box

You did not answer my questions.
--
KARL DEWEY
Build a little - Test a little

Do I place this in the control source for the question that I want to have
automatically populate?

:

Use [Forms]![MainFormName]![SubFormName]![ObjectName]

Is the report name in a label or textbox? If it is the data in a text box
it will work but I do not think you can pull from a label.
--
KARL DEWEY
Build a little - Test a little


:

I am using a sub form in my form. I need to know if there is a way to use
information on the subform to auto populate a field on the form? I have a
report name in the sub form, I want a validation question to populate on my
other form based on what the report name is.

Any help would be great appreciated.

Thank you