Solved Copy current form/subform to a new form/subform (1 Viewer)

[Leo_Polla_Psemata]

Hi, I have a form/subform, one to many.
This is about a quotation.
On the form, I display the main quotation details (quotation number, customer name /customer folder number, validity, etc)
while in subform (data sheet format) I type the cost, charges, surcharges. Each form has minimum 4 records in subform.

I know how to copy current item to new form (using dlookup) , but I can’t copy the items from the subform on the new form/subform.

So far, I copy paste manually, is there any way I could copy paste the current form subform to a new form subform ?

 

[theDBguy]

Hi. Have you seen this one?

Microsoft Access tips: Duplicate the record in form and subform (allenbrowne.com)

 

[Leo_Polla_Psemata]

Hi. Have you seen this one?

Microsoft Access tips: Duplicate the record in form and subform (allenbrowne.com)

Hi , i have converted this code to my database field names.
I get the error
"Compile Error: Method or data member not found"
in this part of code
"FROM [Order Details] WHERE OrderID = " & Me.OrderID & ";" (this is as per Allen Browne example)

"FROM [Of2] WHERE OF1ID = " & Me.OF1ID & ";" (these fields are after i converted Allen Browne code fields to my db fields)

Do you have any idea ? I have reviewed line by line , letter by letter all code parts and i can't find anything not converted well ??!!

 

[Gasman]

Access does not lie
So upload your DB, or show the control properties on the form?
Where is that code actually located as well?

 

[Leo_Polla_Psemata]

Access does not lie
So upload your DB, or show the control properties on the form?
Where is that code actually located as well?

Hi, i will upload, but, this error stands for control property field name error ?

 

[Gasman]

Hi, i will upload, but, this error stands for control property field name error ?

I realise that, but if you cannot see it you need anothers set of eyes. It appears from what you have said, control OF1ID is at fault?

 

[Leo_Polla_Psemata]

I realise that, but if you cannot see it you need anothers set of eyes. It appears from what you have said, control OF1ID is at fault?

Yes, the code highlights exactly this part, now i am not on my work station and can't copy paste but this is it

 

[Leo_Polla_Psemata]

Okay, i found it and now works perfectly.
I should type correctly the field property (not the control source)

Now works

 

[theDBguy]

Okay, i found it and now works perfectly.
I should type correctly the field property (not the control source)

Now works

Congratulations! Glad to hear you got it sorted out. Good luck with your project.