Discussion Locked

Access Foms and Subforms

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a form in Access with a field named "Date". When I click on a button that allows me to open a second form, I want the data in the "Date" field on the first form to appear in teh "Date" on the second form. I just can't seem to get this to work. I've tried all kinds of code, but I feel that I am missing something.

3 replies

by gher_rick

You might try to use the OpenArgs when you open the second form.
I assume that you are using code to open the second form. If so, then reference the 'date' in the Docmd.OpenForm line of code in the OpenArgs spot. On the second form, change the default value of the 'date' field to '=OpenArgs'

Hope this helps.

by Former member

This question was closed by the author

This discussion is closed to new replies.