By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,165 Members | 849 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,165 IT Pros & Developers. It's quick & easy.

Combo Box and text box - can anybody help???

P: n/a
I have two controls in a form:

1) A named text box
2) A named combo Box

Where and what type of expression would I enter to insert the current
date into the named text box if a user selects data from the combo

I think the code should be something like below but not sure:

If [Named Combo box] is Not Null THEN [Field Name] = Date()
Else [Field Name] = Null
Thank you

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
On After Update

Nov 13 '05 #2

P: n/a
Instead of
IF [Named Combo box] is Not Null
You'll need
IF Not IsNull([Named Combo box])
Is Not Null is query language and is not supported in VBA


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.