Problem referencing variables between forms

[Pete Beatty]

I have been out of the VBA programming for a while and am stumbling on what
should be a simple problem that I NEED HELP with.

I have developed one form that has defined two public variables (rst1 as
dao.recordset and rst2 as dao.recordset).

Using the two variables I retrieve records from both files and compare the
fields. when an error is detected, I open another form which is supposed to
display all of the fields for both records and highlight the differences.

The problem is when I attempt to populate the objects on this new window, I
reference the public variables. This creates an error (e.g. "object
required"). the code I use is
me!object1.value = rst1![field1]

I am at a loss. Please assist.

 

[Ron Weiner]

Pete

Try
forms!YourFormName.rst1!field1
If rst1 is declared as Public in the Declarations section on your form
(Public rst1 as DAO.Recordset) and your form is not a subform on another
form, and field1 is the name of the field returned by the recordset.

If you form is a Subform then the proper syntax would be:

forms!YourParentFormName.NameOfSubFormCONTROL.Form.rst1!field1

Ron W

 

[Pete Beatty]

Thanks

Pete

Try
forms!YourFormName.rst1!field1
If rst1 is declared as Public in the Declarations section on your form
(Public rst1 as DAO.Recordset) and your form is not a subform on another
form, and field1 is the name of the field returned by the recordset.

If you form is a Subform then the proper syntax would be:

forms!YourParentFormName.NameOfSubFormCONTROL.Form.rst1!field1

Ron W

I have been out of the VBA programming for a while and am stumbling on what
should be a simple problem that I NEED HELP with.

I have developed one form that has defined two public variables (rst1 as
dao.recordset and rst2 as dao.recordset).

Using the two variables I retrieve records from both files and compare
the
fields. when an error is detected, I open another form which is supposed to
display all of the fields for both records and highlight the differences.

The problem is when I attempt to populate the objects on this new window, I
reference the public variables. This creates an error (e.g. "object
required"). the code I use is
me!object1.value = rst1![field1]

I am at a loss. Please assist.