Adding a new recordset within a form

[jokobe]

I'm working in a form, container filtered data from a table.
I have collected data from the clipboard and want to go a new recordset to
insert the data from the clipboard.

Is there a way to reach the new recordset and then insert like

me.theme = strcliptheme
me.author = strclipauthor

thanks in advance

jokobe

 

[Jeff Boyce]

I'm not sure I'm using the same definitions you are in your description.
What do you mean by "a new recordset"?

If your database is well-normalized, it might be a bit unusual to copy,
field-for-field, from one record into a (new) another one.

You've described "how", as in "how you are trying to accomplish something".

If you'll describe "what", as in what will the end-user be able to do once
something (not yet determined how) is finished.

Knowing the underlying business need (what and why) may prompt some of the
readers here to offer alternate approaches.


Regards

Jeff Boyce
Microsoft Office/Access MVP