Can't send a Record Set to a different form in Access 2010

Mark McCumber 431 Reputation points
2023-03-29T16:19:07.6633333+00:00

I have a form that constructs a RecordSet of unique values. I want to send the record set to a different form so I can create a table using the data from the passed record set.

I can send the record set to the new form, but I am getting an error 91 Object not set error when I try to view the record set using a Do Loop in the New Forms Open event.

Can anyone enlighten me how to do this?

Thank you,

MRM256

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
832 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Mark McCumber 431 Reputation points
    2023-04-01T14:58:59.0666667+00:00

    Found the problem.

    If you are passing a RecordSet to another form using the example in my first post. Make sure you define the RecordSet as Public.

    Thanks,

    MRM256

    0 comments No comments