how to keep a record set around

[Guest]

I have a table that I use as a password registry. I use ADO to pull out a
recordset (their password record) and then a form will open where certain
buttons will be disabled, etc. based on what is in the registry with their
password. Is there a way to keep the recordset around so that I can reference
the pw record for use with other forms, etc. that the user may open?

thanks

 

[Wolfgang Kais]

Hello salmonella.

I have a table that I use as a password registry. I use ADO to pull
out a recordset (their password record) and then a form will open
where certain buttons will be disabled, etc. based on what is in the
registry with their password. Is there a way to keep the recordset
around so that I can reference the pw record for use with other forms,
etc. that the user may open?

You could place the public recordset variable in a standard module.
This will survive the forms unless you reset the project.

 

[Van T. Dinh]

If you have a Form that remains open (hidden if required) during the
database session, then simply create a few TextBox to store the required
data from the Recordset.

This way, even if the code project is reset (when the Recordset is likely to
disappear???), e.g. untrapped error, you still have the required values on
the Form.

 

[Guest]

Thanks, i was thinking of doing it this way since it is simple and
straightforward. I will give it a try.