Hi people

HI just wanted to ask...

I have to forms, in the first form i created a recordset (rs) that i want to call and update in the second form, how can I do this??

Thanks a lot!!

Declare the recordset as public.

Or better, put it in a module.

Or even better, in a separate function in a module that you can thus call from anywhere.

Great new 3D frog!!!

i have tried by creating the recordset public, however it didnt work, how modules wrk???

Modules are like chunks of code that just sort of sit there. You can make a Public item and it will work on /any/ form.

So make a new module, name it whatever you like, and put:

VB Code:

Public RC As Recordset

Yeah. Need anymore help?