Hi Everyone!!! Hoping someone can help me with this.
I maintain a database that contains information about apartments that our business rents for clients. Included in the tables are those for landlord info (name, address, etc.) named "landlord", apartment info (address, accounts, etc.) named "apartment", and one for payments made (address, amount, etc.) names "payments".
I have a form setup that enables me to add/update apartment info based on a table named "apartment". Included in this table is the identifier (setup as a combo box) that connects me to the landlord information in a table called "landlord".
What I would like to do is create a code, probably associated with -NotInList- event, that will open the form setup for the landlord info WHEN the landlord identifier is not included in the "landlord" table so that I can add the landlord's information.
Many thanks to those that can help!
Leeann....
I maintain a database that contains information about apartments that our business rents for clients. Included in the tables are those for landlord info (name, address, etc.) named "landlord", apartment info (address, accounts, etc.) named "apartment", and one for payments made (address, amount, etc.) names "payments".
I have a form setup that enables me to add/update apartment info based on a table named "apartment". Included in this table is the identifier (setup as a combo box) that connects me to the landlord information in a table called "landlord".
What I would like to do is create a code, probably associated with -NotInList- event, that will open the form setup for the landlord info WHEN the landlord identifier is not included in the "landlord" table so that I can add the landlord's information.
Many thanks to those that can help!
Leeann....
