Calendar Help!

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
F

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
 
Hi,
On the AfterUpdate event of you calendar control, put
this code:

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

Substitute your control names.
 
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.
 
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.
 
Back
Top