New Recordset

[Bryan Hughes]

Hello,

I have a form that I need to add a command button, that will add a new
client recordset, but I need to keep the current [CaseFileID] the same in
the new client recordset.

How can I do this?

-Bryan

 

[John Vinson]

Hello,

I have a form that I need to add a command button, that will add a new
client recordset, but I need to keep the current [CaseFileID] the same in
the new client recordset.

A "Recordset" is the result of a Query; it might contain any arbitrary
number of records. You wouldn't "add a new recordset" in ordinary
programming. I have to guess that you're using the word with some
other meaning. What do you mean by 'a client recordset' in your case?

 

[John Vinson]

Is this the best way to do this?

Well, since all your constants are exactly the same, containing a
single doublequote charcter, you only need one of them - but other
than that, looks good to me.