Need help with automatically filling in related fields

[Guest]

I have a subform where it lists names of patients associated to Dr on main
form. When entering a date on the first patient. I would like to have the
other dates on the same field for the other patients on the subform. Some
Drs may have one to numerous patients listed. Can this be done? Don't want
to enter the same date numerous times. Can this be done simply without code?
Thank you in advance for any help you can give me.

 

[Albert D.Kallal]

Well, ctrl+' will copy the last entry for the field....

So, you could use that key sequence, and not have to write any code....

Can this be done simply without code?

As mentioned, the above would a code free approach.

For a code approach.....

Use the after update event of the contorl.....


If IsNull(Me.PatientDate) = False Then
Me.PatientDate.DefaultValue = """" & Me.PatientDate & """"
End If



Can this be done simply without code?



Hum, I would go