Duplicating a record o na continous form. 1

[techkenny1]

Hi,

Heres one I am not able to solve.
On a continous form how can the data be duplicated onto the next record. ie: I have a form that has 6 text fields.

I just want to use the [blue]On Dbl Click[/blue] event to duplicate the data onto the next record.

Many thanks,

kp

 

[TheAceMan1]

How are ya techkenny1 . . .

See my post here: thread702-1382356

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[techkenny1]

Hi TheAceman1,

Many thanks for your reply. When I looked at your post it was not what I was looking for to do the job.

[blue]The following allows you to set defaults to any record by double clicking the record selector for that record[/blue].

I would prefer to be able to dbl click the respective text box, so that it then can become selective for the user.

Many thanks,

Kp

 

[TheAceMan1]

techkenny1 . . .

In that case ... in the [blue]Double Click[/blue] event of each control of interest, copy/paste the following line (you substitute proper control names):

[blue]   Me![purple][b]YourCtlName[/b][/purple].DefaultValue = """" & Me![purple][b]YourCtlName[/b][/purple] & """"[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[techkenny1]

TheAceMan1,
Many thanks for that. It works really well.

kp