Hi
1. I have an Access form called frmCustomers in a 2007 db
2. On it is a list box called lisJobs. The content of this is based on a parameter query which uses the value of the current customer ID as its criteria. It takes this from the ID text box on the customer form ie Forms!frmCustomers!txtID
3. This has been working perfectly well and has been since I began development days ago.
4. Suddenly, and for no apparent reason, the criteria value for the list box within the query inexplicably changes to Forms!frmAdmin!txtID.
5. The db does contain a form called frmAdmin but it doesn't have a control on it called txtID. Also the criteria Forms!frmAdmin!txtID has never been used with the lisJobs query or saved in it by error etc.
6. If there is any pattern to this it seems to happen when the form in question is saved. Also frmAdmin is alphabetically the first form on the list. I created another form and named it so it would be first on the list and the parameter in the query now gets replaced with this new form name
There may be an explanation for this but as far as I can see it is totally without logic. Can anyone shed any light on what might be happening????
1. I have an Access form called frmCustomers in a 2007 db
2. On it is a list box called lisJobs. The content of this is based on a parameter query which uses the value of the current customer ID as its criteria. It takes this from the ID text box on the customer form ie Forms!frmCustomers!txtID
3. This has been working perfectly well and has been since I began development days ago.
4. Suddenly, and for no apparent reason, the criteria value for the list box within the query inexplicably changes to Forms!frmAdmin!txtID.
5. The db does contain a form called frmAdmin but it doesn't have a control on it called txtID. Also the criteria Forms!frmAdmin!txtID has never been used with the lisJobs query or saved in it by error etc.
6. If there is any pattern to this it seems to happen when the form in question is saved. Also frmAdmin is alphabetically the first form on the list. I created another form and named it so it would be first on the list and the parameter in the query now gets replaced with this new form name
There may be an explanation for this but as far as I can see it is totally without logic. Can anyone shed any light on what might be happening????
