Problem with running code to insert previous record data in form

[LadyL]

My database runs fine, the final element that I need to work is that my button "Gegevens invullen" in the form "Vondsten" does not work. I get the error Invalid Argument. This code works fine on other forms however. I've already omitted 'categorie' in case it would cause problems, but no solution. Any ideas? Also I cannot seem to edit my last posts in order to remove the database from them.

[June7]

I think regular members can edit posts for only a limited time. A moderator can edit posts at any time. I have done so. Most posters aren't concerned with leaving attachments. I will look at your revised db.

[LadyL]

Thank you, really appreciate your help

[June7]

Still get compile errors with your code. Still get errors on missing members for Zoekformulier - why? I would expect these issues to be resolved by now. Have you run Debug Compile? There is an Option Explicit line in the middle of code just above the CarryOver function. Remove that line.

[LadyL]

Ah yes, I don't actually use that code for Zoekformulier, so I've removed it. And I have removed the Option Explicit, but still no luck.

[June7]

The CarryOver function has 3 arguments but you are trying to pass 4. I find it odd that the compiler does not error on the function call with 4 parameters. Are the last two parameters accepted as elements of the array expected by the function? I never tried passing array elements like this. What is data in the array for? It seems to be a list of controls that should be skipped in the looping structure. Should multi-value comboboxes be skipped?

Only cause of issue I can see is that the record includes a multi-value field. Copying multi-value field data to another record requires code that manipulates a child recordset. Review: https://www.accessforums.net/program...vba-21259.html

But you say other forms work even though they have multi-value field involved.

[LadyL]

I figured it out, it seemed it was because of the categorie field. I changed the relationship type and it suddenly works.