Control with suffix

[DCV0204]

Ok I need some help...

I have a control named "DCV" on my form that is linked to a table named "Research".
"DCV" is a text field. I would like to enter my 4 digit number into the "DCV" field and when I exit (any event) the field I would like the current date to populate next to the 4 digit code.

example:
If I type in 4601
When I exit the field, I would like it to contain: 4601_05/10/2013 (representing today's date)

Is this even possible without creating an additional field and performing an update query?
Thanks,


Lisa

[June7]

Why do you need to combine data? It would be easier to have a separate field with a DefaultValue of Date().

[DCV0204]

If it is possible to have 2 different Date() associated with 2 different fields that would be great.
Is this possible?
I have 2 fields that when they are populated I would like the Date field to represent the auto date the fields were populated.
For Example:
My field names are: Researched By: and Purged By: lets say that the person that researched the data completed the research on 5/8/2013 and the date the other person purged the documents was 5/10/2013.
I would like the the data to look lik this:
Research By | Research Date | Purged By | Purged Date
0204 05/08/2013 2027 05/10/2013

I would like the dates to auto populate when the Research By field is exited.
Thanks,
Lisa

[orange]

As June7 has mentioned, in relational databases the best practice is to use atomic data -- that is one fact in one field.
You can have as many relevant dates as you need to support your business. Each fact/field needs to have a unique name to distinguish one from another. You may want to research NORMALIZATION, a method for designing and relating tables.
Here is one link, there are many "findable" via Google search,
http://support.microsoft.com/kb/283878

[DCV0204]

So you can not provid me with an example with the data I have provided?

[Rainlover]

It is best to work with your data but the Northwind Database which comes with Access will show you a correct setup.

Are you going to post your Relationship window or are you having problems.

[orange]

Example of what? You showed only 4 fields. What sort of research? How many researchers? Locations? Reasons/rationale?
What is the Business and business rules? How many tables involved? What relationships?

Here's your own example of multiple Dates

Research By | Research Date | Purged By | Purged Date
  0204            05/08/2013       2027           05/10/2013

Whatever DCV is -control, field in a table.... - it should be separate.
If the DCV code number is important to you, then you name it and value it as you see fit.
I recommend you have a Primary key on your table(s), that has meaning to Access. I would recommend this be autonumber.

You could automatically assign a Date to a field via an Event Procedure.
eg, AfterUpdate of PurgeBy, you could assign Date() to PurgedDate.

I also recommend you do NOT use names with embedded spaces, or other special characters (!@#$%^&*+-=)

[DCV0204]

Ok, I will try and explain what I am wanting one more time.
I have a form that is linked to a table which contains many data elements.
When staff types in information into the "Research By" field I would like for the "Research date" to be auto populated with the Date() it was actually keyed.
When the next staff person enters information in the "Purged By" field I would like for the "Purge Date" to be auto populated with the Date() it was actually keyed.

So, is there code that can be written if the "Research By" field is updated then populate the "Research Date" field with Date()? and
if the "Purge By" field is updated then populate the "Purge Date" field with Date()?

[orange]

As per my last post

You could automatically assign a Date to a field via an Event Procedure.
eg, AfterUpdate of PurgeBy, you could assign Date() to PurgedDate.

Sample code(an existing AfterUpdate event not specific to your issue) - just an example of an AfterUpdate

Private Sub cboShift_AfterUpdate()
   Me.txtShiftStartDate = Format(Now, "mm/dd/yyyy hh:nn:ss")
End Sub

[Rainlover]

Me.NameOfDateField = Date()

That's all you need in the event.

I am sure Orange understands your problem.

[DCV0204]

I will try this thanks.

[Rainlover]

One other thing.

Date() will return today's Date.

Now() will Return today's Date plus the time it is now.

[DCV0204]

Rainlover, thanks alot....this worked.