The project Im redesigning is a relatively simple accounting program with a few special requirements; the accounts are in different countries/currencies and the accounts are in different companies with a number of accounts types in the same company.  All the tables have the same structure and field names.  I use a Object Naming Structure that Identifies the County, Company, Account Number, Account Name and Object Type in the object name.  All the objects base numbers are stored in a helper table, Accts_HT.    [IDA], [AccountName], [Obj].
It is very easy to develop a new account, tables, forms, queries, and reports.  All I need to do to add the account, is copy the table, form, query, report and change its target source and name. I spend a lot of time making the Forms and Reports correct before implementing the other accounts.
Designing the NDTSB1_F form, I use the Accts_HT data to Display the [AccountName] field with a combo and hopefully identify the [Obj] field but the combo changes to the [AccountName]. I want to use the second column not the first.  Ive been reviewing Richards videos trying to find how to do this.  I think I remember him indicating how to do this but I cant seem to find it.
The person using the database is not very computer literate, so the requirement is buttons for everything. The NDTSB1_F form use two buttons, RegRptButton and ReturnButton.  Right now, the use a macro to open the Report and close the form Window.  Is there a way to use the [Obj] field to implement VBA to open the report and close a window? That would make coping the form/reports easy.  Again only changing the record source and object name.