Adding to open record on form, from unbound textbox
I have a DB that tracks work for employees, the employee logs in and that information is stored in a temp table/query. Them the employee goes to a form and works based on date range for the assignments.
So the problem that I am running in to is, I am trying to add the person and date of when the assignment is complete. So I tried adding VBA to OnClick for the yes/no for the completed field. I created two text boxes one is a d-lookup for the employee and the other is the text box for the date.
Please let me know if addition information is needed.
So the problem that I am running in to is, I am trying to add the person and date of when the assignment is complete. So I tried adding VBA to OnClick for the yes/no for the completed field. I created two text boxes one is a d-lookup for the employee and the other is the text box for the date.
Please let me know if addition information is needed.
Who is Participating?
Where are you adding the Date the Assignment is complete?
And how do you determine if it is Complete?
Remember that we cannot see your screen, so referring to things like "completed field" means nothing to us.
If your goal is to "stamp" records with the current user and time, then I generally leave the login form open but hidden, and refer back to that form to get the username. If you want to get the current date, just use Now() or Date()
And how do you determine if it is Complete?
Remember that we cannot see your screen, so referring to things like "completed field" means nothing to us.
If your goal is to "stamp" records with the current user and time, then I generally leave the login form open but hidden, and refer back to that form to get the username. If you want to get the current date, just use Now() or Date()
Sorry for the delay, still learning Experts Exchange.
I have attached a screen shoot.
#1 on screen shoot is the unbound fields that I want to update 2
#2 on screen shoot is the is the bound field for the open report.
#3 on screen shoot is the OnClick for completed.
Sorry for lack of information. still learning all of this.
I have attached a screen shoot.
#1 on screen shoot is the unbound fields that I want to update 2
#2 on screen shoot is the is the bound field for the open report.
#3 on screen shoot is the OnClick for completed.
Sorry for lack of information. still learning all of this.
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
If so, then you could do this in the AfterUpdate event of the Completed checkbox:
Me.CompletedBy = Me.QNumber
Me.CompletedDate = Me.QDate
Of course, I have no idea of the names of your Controls on that Form, so you'd have to change those to match the ones in your form. In the example I gave, the two items on the left side of the equal mark are the items in #2, and the two items on the right side of the equal marks are the items in #1.