I have two versions of the same form, one for creating a new record, and one for viewing it once it's created.
Both forms have a textbox called Date, which are identical except for one is Unbound and one is bound to the Date field from a table.
The Datepicker only appears on the Unbound textbox - if I unbind the textbox on the viewing form, it reappears.
Why is this? Is there any way of getting a datepicker...
ojeffery
Last Activity: Nov 28 '12, 12:06 PM
Joined: Oct 19 '11
Location:
-
Datepicker not appearing on Bound Control
-
Brilliant, that works! Thanks to sierra7 and TheSmileyCoder! -
Thanks for your reply. Yes, code appears to be running - I've tried putting msgboxes after each significant bit of code to check, which still come up. It works fine when the "Results Subform" is open as a form in itself, but not when it's a subform. Could it be that "me" is referring to the parent rather than the subform?Leave a comment:
-
Changing the OrderBy of a subform programatically
I have a Form with a (Continuous) Subform that lists the results of a query. There's a header within the Subform that has several elements you can click on to programatticaly change the OrderBy of the Subform then refresh it. An example of the code I use is here:
...Code:Private Sub CompanySort_Click() If (Me.OrderBy = "Company") Then Me.OrderBy = "Company DESC" Else Me.OrderBy = "Company"
No activity results to display
Leave a comment: