Hi,
I've got a calculated text box on my main form that has the following control source:
Pretty self explanatory, but basically it displays the value in the [MainChild] field into a text box at the top of the form.
It worked absolutely fine and displayed what I wanted it to, until I closed and re-opened the database and then found it was displaying #Name?
I eventually solved the problem by creating a new database and importing all objects into it. However, I do have a few questions:
1) Is there any reason why this happened, or is it just some sort of corruption and it comes down to me being unlucky?
2) Is there any way to ensure it doesn't happen again?
3) When I imported all objects into my newly created database, is there anything that would not have been copied over? For example, in my original database I had the database opening on a Switchboard form. In my new database I had to go back into database options and re-do the setting that makes it open on the Switchboard form. Whereas this wasn't a big issue, I'm worried that there may be other smaller, less noticeable things that don't copy over when you import objects to a new database.
Thanks.
I've got a calculated text box on my main form that has the following control source:
Code:
="Currently Selected: " & [MainChild] & " & family"
Pretty self explanatory, but basically it displays the value in the [MainChild] field into a text box at the top of the form.
It worked absolutely fine and displayed what I wanted it to, until I closed and re-opened the database and then found it was displaying #Name?
I eventually solved the problem by creating a new database and importing all objects into it. However, I do have a few questions:
1) Is there any reason why this happened, or is it just some sort of corruption and it comes down to me being unlucky?
2) Is there any way to ensure it doesn't happen again?
3) When I imported all objects into my newly created database, is there anything that would not have been copied over? For example, in my original database I had the database opening on a Switchboard form. In my new database I had to go back into database options and re-do the setting that makes it open on the Switchboard form. Whereas this wasn't a big issue, I'm worried that there may be other smaller, less noticeable things that don't copy over when you import objects to a new database.
Thanks.