How do I add a date from a form to a subform

G

Guest

I have a form that has a subform attached. I want the date field in the
subform to automatically take the date from the form date field. The form
places data in a table with AutoNumber; Date; and Shift. The subform is tied
to the form (AutoNumber = Num). I will have only one entry in the form but
several enties in the subform. How do I get the Date in the subform to
automatically take the date of the form date.
 
J

John Vinson

I have a form that has a subform attached. I want the date field in the
subform to automatically take the date from the form date field. The form
places data in a table with AutoNumber; Date; and Shift. The subform is tied
to the form (AutoNumber = Num). I will have only one entry in the form but
several enties in the subform. How do I get the Date in the subform to
automatically take the date of the form date.

The simplest way would be to include both the autonumber and date
fields in the Master/Child Link Field properties of the subform,
separated by semicolons. They'll both fill in.

John W. Vinson[MVP]
 
G

Guest

John Vinson said:
The simplest way would be to include both the autonumber and date
fields in the Master/Child Link Field properties of the subform,
separated by semicolons. They'll both fill in.

John W. Vinson[MVP]
Thank You. I'm new to Access and somehow knew it would be simple. Thanks
again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top