Custom Create a New Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I need to make a command that duplicates a record, but before creating the
new records, asks for a new "Job Name" then changes the Related Feilds
throughout the form.

Is this possible?
 
Yes. One way to do this is put the value of each control in the control's
Tag property. Then go to a new record and put the Tag value back in the
control.

Private Sub cmdDupRec_Click()

With Me
.AControl.Tag = .AControl.Value
.AnotherControl.Tag = .AnotherControl.Value
End With

DoCmd.GoToRecord , , acNewRec

With Me
.AControl = .AControl.Tag
.AnotherControl = .AnotherControl.Tag
End With

Me.txtJobNumber.SetFocus

End Sub
 

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

Subform New Record 2
Access Automatically Send a notification email once a record is added 0
create a form with mutiple fields 1
primary key duplicate record is not incremental 2
Duplicate Subform and SubSubForm Records but not Main 1
Separate Form 0
Add New Record Button: How to Get Mouse Cursor in Specific Field Upon Clicking? 1
DMax on existing record to increment serialized # fails 1

Back
Top