Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DatePicker in grid subform
- Thread starter onana
- Start date
Hi onana,
I take it your subform is a continious type (multi record)
it seems that access won't allow you to do that! you may be able to add similar functionality by having your date field on the form and set the data picker on an unbound form, have it so that if the user clicks (double clicks might be better) on it, you pop up the form with the date picker after the user selects the date
use something like
forms![YourMainFrom]![YourSubForm].Form![YourDateField] = me."datePicker".value
you'll need to use the names of the forms and fields to suit your situation and the name you give to the datepicker control.
HTH
[sig]<p>Robert Dwyer<br><a href=mailto:rdwyer@orion-online.com.au>rdwyer@orion-online.com.au</a><br>[/sig]
I take it your subform is a continious type (multi record)
it seems that access won't allow you to do that! you may be able to add similar functionality by having your date field on the form and set the data picker on an unbound form, have it so that if the user clicks (double clicks might be better) on it, you pop up the form with the date picker after the user selects the date
use something like
forms![YourMainFrom]![YourSubForm].Form![YourDateField] = me."datePicker".value
you'll need to use the names of the forms and fields to suit your situation and the name you give to the datepicker control.
HTH
[sig]<p>Robert Dwyer<br><a href=mailto:rdwyer@orion-online.com.au>rdwyer@orion-online.com.au</a><br>[/sig]
- Status
Similar threads
- Locked
- Question
- Locked
- Question