Auto filling a field on a form?

[jackie77]

Hi all

I have a form with 2 combo fields one which shows who a job is initally assigned to, called Initials and one which shows who actually carried out the job called Initals2

what I want it to do is to automatically copy the name in the initials field to the initials2 field but be able to change if necessary

I have managed to do the first part and i can sucessfully copy the name to the field however it will not let me change it

the code I have use is

Private Sub Initials2_BeforeUpdate(Cancel As Integer)
Me.Initials2 = Me.Initials
End Sub

Any suggestions?

Cheers

Jackie

 

[wazz]

the code you've shown is on Initials2 and it is changing itself to equal Initials no matter what: Initials2=Initials. according to your description you don't want any code on Initials2. you want this on Initials and nothing else:

Private Sub Initials_AfterUpdate()
Me.Initials2 = Me.Initials
End Sub

 

[jackie77]

Doh!! thanks wazz how stupid am I of course it is, I have been spending hours on this stupid db that I think my head has turned to mush, I think its time to take a break!

thanks again

jackie