cloning a record

G

Guest

I am using the following code in a button on the form to clone a record in
the subform.

With Me![Employee subform].Form.RecordsetClone
.AddNew
!EmployeeID = Me![Employee subform].Form![EmployeeID]
!Dept = Me![Employee subform].Form![Dept]
!Subdept = Me![Employee subform].Form![Subdept]
!Wage = Me![Employee subform].Form![Wage]
!HrsWrk_basic = 36
.Update
End With


I want to change the code so that it can be used in an update event in the
subform. I appreciate it can't be that difficult but not too sure how to
change the first line.

thanks
 
S

Scott McDaniel

I am using the following code in a button on the form to clone a record in
the subform.

With Me![Employee subform].Form.RecordsetClone
.AddNew
!EmployeeID = Me![Employee subform].Form![EmployeeID]
!Dept = Me![Employee subform].Form![Dept]
!Subdept = Me![Employee subform].Form![Subdept]
!Wage = Me![Employee subform].Form![Wage]
!HrsWrk_basic = 36
.Update
End With


I want to change the code so that it can be used in an update event in the
subform. I appreciate it can't be that difficult but not too sure how to
change the first line.
Click to expand...

Change any of these:

Me![Employee subform].Form

to just

Me

So Me![Employee subform].Form![EmployeeID] would become Me![EmployeeID]
thanks
Click to expand...

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
G

Guest

thanks for the clarification. Its the first line I'm not sure about.

"With Me![Employee subform].Form.RecordsetClone"




Scott McDaniel said:
I am using the following code in a button on the form to clone a record in
the subform.

With Me![Employee subform].Form.RecordsetClone
.AddNew
!EmployeeID = Me![Employee subform].Form![EmployeeID]
!Dept = Me![Employee subform].Form![Dept]
!Subdept = Me![Employee subform].Form![Subdept]
!Wage = Me![Employee subform].Form![Wage]
!HrsWrk_basic = 36
.Update
End With


I want to change the code so that it can be used in an update event in the
subform. I appreciate it can't be that difficult but not too sure how to
change the first line.
Click to expand...

Change any of these:

Me![Employee subform].Form

to just

Me

So Me![Employee subform].Form![EmployeeID] would become Me![EmployeeID]
thanks
Click to expand...

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
Click to expand...
 
G

Guest

I won't start a new message. I think my problem can be solved a bit more
easily.

Thanks for the heads up.


Scott McDaniel said:
thanks for the clarification. Its the first line I'm not sure about.

"With Me![Employee subform].Form.RecordsetClone"
Click to expand...

That should be Me.RecordsetClone

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

replicating a record: quick query. 1
Choose a record without making a subform 6
open form/subform to last record 1
Requery subform Field based on different Field's value 0
Subform linking problem 4
Comparing data between a field and the values in a query 1
GoTo a record from a combo in the form 4
Trouble with inserting a Subform within an existing form 4

Top