In my database I am creating, I have a form that open on startup, which contains a warning to users about breaches of confidentiality etc (frmStartup). There is a field in this form that contains the branch name of the company. If this is blank or contains "XXX" then a further form will popup, requiring the user to input the name of the branch (frmLocation). This form is linked to a table (tblLocation).
Once frmLocation is updated, the branch name in frmStartup is updated to reflect the branch name.
Now, when the user clicks on the OK button on the frmStartup form, it closes the frmStartup, and opens a menu form (frmMenu). I want this form to also reflect the branch name, but when I try to link a text field to tblLocation or a query, the database tells me that tblLocation is already in use.
How can I overcome this problem.
I later want to use the branch name in reports as well.
Any assistance would be appreciated.
Once frmLocation is updated, the branch name in frmStartup is updated to reflect the branch name.
Now, when the user clicks on the OK button on the frmStartup form, it closes the frmStartup, and opens a menu form (frmMenu). I want this form to also reflect the branch name, but when I try to link a text field to tblLocation or a query, the database tells me that tblLocation is already in use.
How can I overcome this problem.
I later want to use the branch name in reports as well.
Any assistance would be appreciated.