Form List to base form

Topic

New Reply

This is soo simple – but I cannot get it right!
I have a form with a list of records in it, when I click on a macro button the base form is supposed to open up.
The list form and field on it is : FrmTaxReturnsList [TRRecord]

Now I want to go to the base form with this field on it : FrmTaxReturns01 [TRRecord]

The macro is open form FrmTaxReturns01 where
[TRRecord]=[Forms]![FrmReturnsStatusList]![TRRecord]

Unfortunately it does not work. Help with this please.

Reply | Quote

Replies

Could you post a stripped down and zipped copy of your database?

[*]Make a copy of the database (in Access 2000 or 2002-2003 format) and work with that.
[*]Remove all database objects (tables, queries, forms, reports, macros and modules) that are not relevant to the problem.
[*]In the remaining table(s), remove most records – leave only the minimum number necessary to demonstrate the problem.
[*]Remove or modify data of a confidential nature.
[*]Perform a compact and repair (Tools/Database Utilities).
[*]Make a zip file containing the database.
[*]If you have difficulties getting the zip file reasonably small, save the database in Access 97 format and then zip it.
[*]Attach the zip file to a reply.

Reply | Quote

Could you post a stripped down and zipped copy of your database?

[*]Make a copy of the database (in Access 2000 or 2002-2003 format) and work with that.
[*]Remove all database objects (tables, queries, forms, reports, macros and modules) that are not relevant to the problem.
[*]In the remaining table(s), remove most records – leave only the minimum number necessary to demonstrate the problem.
[*]Remove or modify data of a confidential nature.
[*]Perform a compact and repair (Tools/Database Utilities).
[*]Make a zip file containing the database.
[*]If you have difficulties getting the zip file reasonably small, save the database in Access 97 format and then zip it.
[*]Attach the zip file to a reply.

Hi Hans, thanks for the advice – now found out that the form name being used in the macro was wrong! Once again thanks.

Reply | Quote