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

A multi value select field auto populates a date field when data is selected

P: 9
Hello: I have a form in Access2010
[field 1]- Missing Information- multi value select field
field 2]- Date Missing Email Sent - calendar date field.
End users request to have [field 2] populate a future date if [field 1] has been populated.
Date field will remail blank if nothing is populated in field 1
I would desire to use a easy code in the after update event.I believe that I butchered it
Expand|Select|Wrap|Line Numbers
  1. [Missing_Information] IsNotNull and DateAdd("d", 1, Me.Date_Missing_Email_Sent_to_CPNM)
I receive a Compile Error; Invalid use of property
Aug 24 '17 #1
Share this Question
Share on Google+
5 Replies

Expert Mod 15k+
P: 31,487
Please include the full procedure. A single line of code is rarely enough of the story to work with. Certainly not in this case.
Aug 25 '17 #2

P: 9
sorry don't understand what your asking, the full procedure is listed. I tried to use one line of code.
If [Missing info] field is null in then [date field] is not auto populated. If end user populates the missing info field then the date field auto populates .
Aug 25 '17 #3

Expert Mod 15k+
P: 31,487
Perhaps if I give an example of a procedure that has only a single line of executable code :
Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Open(Cancel As Integer)
  2.     strWhere = Nz(Me.OpenArgs, "")
  3. End Sub
You'll notice that the header and footer lines are included which then means we don't have to ask such questions as :
  1. What's the name of the Control the event's for?
  2. Which event are you utilising for this code?
It also makes clear that there's only one line of executable code, of course.
Aug 25 '17 #4

P: 9
Hi I am not a coder that is why I am asking for assistance. I explained previously what I am trying to accomplish with the two fields, If you don't want to assist then don't. If you want to nit pic please move on. I just joined this site for assistance and direction. THanks
Aug 25 '17 #5

Expert Mod 15k+
P: 31,487
I appreciate you're not a coder. That's why I've explained what I need, in order to be able to help you, in such a clear manner.

Your earlier explanation was woefully inadequate. Hence I was helping by explaining how to get the question into such a state that I, and others possibly, could begin to help you.

Obviously, it's your choice how you respond to those that try to help you, but you should understand that some responses can make you generally unpopular very quickly. Not a good place to be if you rely on others to offer you their help.
Aug 25 '17 #6

Post your reply

Sign in to post your reply or Sign up for a free account.