checkbox and Textbox link

[rebel_yell]

Hiya!

Beginner here so apologies in advance if there is already a thread about this.



My question is; is there a way that once a checkbox is ticked (returns TRUE) can it populate the time, date and current user at the same time.

ive got separate fields for this, however, nothing i have tried actually returns any result!

Any help is appreciated

thanks in advance

adam

[alansidman]

In your afterupdate event for the checkbox, something along these lines. Change Control names to what is in your Form.

If me.chkboxName = TRUE then
me.TimeNameField = Time
me.DateNameField = Date
me.UserNameField = Environ("UserName")
End if

[rebel_yell]

Hi!

This, is awesome, however, the case already has a time field in it and when the code is ran, it updates both time fields - i can only assume that it would be the same for the date too?

is there any way of keeping the original values in the existing record field and update the new fields with the new information?

thanks again

adam

[rebel_yell]

apologies - the above is incorrect - it just mirrors the existing time in the record i.e: time logged - 15:17:30 - then your updated time mirrors this - whereas i need this to be the time the checkbox is ticked?

sorry to be a pain

adam

[June7]

What are the names of fields? Alan's code should be doing exactly what you want, populating only the referenced fields with current date/time and user. Why aren't date/time in a single field?

[rebel_yell]

hiya june7

there are two different date fields, the date the record was logged and the date it was amedned; let me tell you about what im trying to achieve.

as a call centre, sometimes when we are innundated with calls we take a 'callback' currently these are kept on paper and are often lost / thrown away / not done so we have decided to set up a database to log who takes the call back and when - but also when the call back is actually dialled on and who by.

alans information is spot on, but as there is already a date/time field in the record, it seems to be populating the same time as the time the record was logged (the time the original call was taken) and not populating the time the time it was dialled on to return the call to the customer (operated by the dialled y/n checkbox)

would i help if i uploaded the database? its not all that big as still in development

thanks

adam

[June7]

By all means, provide db. Never hurts.

[rebel_yell]

it appears its too large. 1.3mb

heres a link to the google drive where you can get it

https://drive.google.com/file/d/0B8J...it?usp=sharing

thanks

adam :0

[June7]

Run Compact & Repair then zip the db. 2MB zip attachment is allowed.

Date and Time are reserved words (because they are functions). Should not use reserved words as field names. Also advise no spaces or special characters/punctuation (underscore is exception) in naming convention.

Presume form involved is [Callbacks to Call].

Bizarre, even after changing field names, the Dialled date and time saved is still same as the login date and time.

More weirdness - VBA events run but debug doesn't stop on breakpoint. Never seen this before. Makes debugging a bit difficult.

I have no explanation for this other than possible corruption - which is usually the case with bizarre and weird. I created a new form with new controls and the code correctly populates the Dialled_by, Dialled_On, Dialled_Time textboxes. However, still doesn't stop on breakpoints.

[rebel_yell]

sorry for the horrendously late reply, had a lot on my plate!

do you think that by changing the date/time fields would resolve the situation?

[June7]

Changing them how - making a single field? No, don't think that will fix the issue. Note my comment about creating a new form.