Alteration to BeforeUpdate

B

Bob

-- Private Sub Combo329_BeforeUpdate(Cancel As Integer)
Me.tbSpellingDate = Format(Date, "dd-mmm-yy")
End Sub

Can this BeforeUpdate be changed , as the only two options it does have are
Yes;N/A

[Yes] enters date

[N/A] enters Blank



TIA Bob
 
J

JK

Bob,

Use the AfterUpdate event

Me.SpellingDate = IIf(Me.SpellingDate="Yes", something, something else)

Regards
Jacob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
BeforeUpdate on a non-bound field doesn't work? 1
DMax on existing record to increment serialized # fails 1
Space at end of multi page list to accommodate new entries 1
How to enter a date in DD-MM-YYYY format 2
Date Format Code 3
Combo box to control two sub forms 2
complicated subform beforeupdate 1

Top