Results 1 to 5 of 5

Thread: Hi people

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Mar 2004
    Posts
    137

    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!!

  2. #2
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170
    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.

  3. #3
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758
    Great new 3D frog!!!

  4. #4

    Thread Starter
    Addicted Member
    Join Date
    Mar 2004
    Posts
    137
    i have tried by creating the recordset public, however it didnt work, how modules wrk???

  5. #5
    Frenzied Member macai's Avatar
    Join Date
    Jul 2001
    Location
    Napanoch NY
    Posts
    1,228
    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:
    1. Public RC As Recordset
    Yeah. Need anymore help?
    Luke

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width