Global variable for recordcount

[Larryg]

Hello All;

I have a form (form#1) that creates a recordset. That recordset populates another form (form#2). I want the recordcount (MyRecordCount) generated from form #1 to be available to use on form#2 after form #1 closes.
I have tried:
Option Compare Database
Public MyRecordCount as Long
Option Explicit
on form #1
and tried using the MyRecordCount value on form #2, but I get an error of "The expression you entered refers to an object that is closed or doesn't exist".
MyRecordCount displays just fine on form #1.



Form#1 has been loading the records onto form#2 as intended, I just need the total recordcount of the recordset to be available for a display on form #2. I have also tried the TempVars method also with no luck. I suspect I'm not putting the code in the correct areas.
I can't use a rs.MoveLast rs.MoveFirst procedure again because I don't want to lose my place in the recordset.
(On form#2 the user enters data, then saves the record, and I have a MoveNext command to get the next record. The order of the "Next" record matters due to date/time priority of the next record.)

Any suggestions?

Thanks...

[andy49]

You can pass variables like your recordcount on the openform function as a parameter


Sent from my iPhone using Tapatalk

[Larryg]

You can pass variables like your recordcount on the openform function as a parameter


Sent from my iPhone using Tapatalk

So are you indicating that it can not be a Global variable? And doing it your way, are you talking OpenArgs?

Thanks...

[andy49]

Open Args is what I was referring to


Sent from my iPhone using Tapatalk

[andy49]

Are you declaring your global variable through the form? It can only be accessed whilst the form is open.

It's better to declare a global variable through a module

See attached.




Sent from my iPhone using Tapatalk