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
Welthey said:
The report name is in a text box
KARL DEWEY said:
You did not answer my questions.
--
KARL DEWEY
Build a little - Test a little
Welthey said:
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
