Enable after Update from Calendar

[CCRT]

I can't seem to find the correct method to enable "Command8"

"TextEndDate" is the field on the form that is pouplated by a calendar.

I'm trying to make the Command8 object only available after the "TextEndDate" is populated.

Thanks

--Dave

Private Sub Form_Load()

Forms!frmDateCriteria.Command8.Enabled = False

End Sub




Private Sub TextEndDate_AfterUpdate()
'Enable Command8
    Forms!frmDateCriteria.Command8.Enabled = True
End Sub

http://home.comcast.net/~ccrt-racing/ccrt.htm

 

[Remou]

Hi
I guess you are filling in TextEnddate with code. This will not cause the After Update Event to fire. You need to enable the control when you are setting the value for TextEnddate.

 

[LittleSmudge]

First off :-

"TextEndDate" is the field on the form

This cannot possibly be true as 'Fields' do not exist on forms. Fields exist in Tables. "Controls" exist on forms

If "TextEndDate" and "Command8" are both controls on the form "frmDateCriteria" then you can drop all the "Forms!frmDateCriteria" referencing - it is unnecessary

( Before you go too much further you really aught to rename Command8 to something more meaningful )

Then put the Command8.Enabled = True line at the end of the code that writes the data to the control.

What you ACTULLY need is something more like

Command8.Enabled = (Len(Nz(TextEndDate,"")) > 0)
so that Command8 gets disabled if TextEndDate gets cleared.


'ope-that-'elps.






G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.