Calendar Help!

[Floyd Forbes]

I have a calendar on a main Form. How do I get the date to
show in a text box on a subform on that same main Form.
How do you link the calendar to the subform controls.

Floyd

 

[Dan Artuso]

Hi,
On the AfterUpdate event of you calendar control, put
this code:

Me.NameOfSubformControl.Form!NameOfTextbox = Me.NameOfCalendar Control

Substitute your control names.

 

[Floyd Forbes]

Thanks! How do I put the date in one field at a time and
not all fields.

 

[MikeB]

Floyd,
At http://www.byerley.net/BdcDownSup.htm scroll down to the AccessCalDemo.Zip file. This contains
a Sample A2K database with a Calendar Form that can be called from a Form or SubForm and even works
in datasheet view. There is ample comments in the code to help you adapt it for your own use.

 

[Dan Artuso]

Hi,
Check out the sample that MikeB pointed out.
Is the control you're putting the date in unbound?
The way unbound controls work in datasheet view is that they are really
all the same control. So when you put a value in one, it displays in all of them.

If that's the case, consider binding the control to a table field.