Use the form references in a query or SQL string as the recordsource for the
subform then Requery the subform in the click event of the dialog form. You
can do that by either just ostensibly changing the rowsource:
Forms!FormName!subformName.Form.RowSource = "Select ..."
or if you've used the form reference in your query:
Forms!FormName!subformName.Form.Requery
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
".::Kay-Dija::." wrote in message
...
I am about to try those suggestions... But what about getting the main
form
to display the information that the user typed in such as the Employee
Name,
the Vacation Start Date and the Vacation End date in the main form. I have
gotten the records to show in the datasheet. For example:
QUESTION USER ENTERS
What is the emplouee name John Allen
Vacation Start Date Jan-3-2005
Vaction End Date Jan-6-2005
How would I get the information to display this in the main form:
Employee Name: John Allen
Vacation Start Date: Jan 3 2005
Vacation End Date: Jan 6 2005
Is there a way that I can recall what the user entered in and assigned
those
values to text boxes in my form? Keep in mind that the promts come from
the
subform that displays the filtered information. Can anyone help me with
this?