I am trying to add to the combo box of clients. I have used the Orders.db as a template for coding. The only difference to Orders.db is that I am not directly inputting new client info onto the same form but a completely separate form "Clients".
I get as far as opening the Client form, entering the details, closing the form and that's when the problem starts, I keep getting a 2118 error then the "Text not in list" comes up even through I have added acDataErrContinue to avoid the message.
If I try to reenter the newly created client in the combo box, it just triggers the entire process again. As I said the only difference in the coding, it that I am calling the form instead of presenting an empty form for the user to enter as the form calling it doesn't need all of the info.
I tried forcing the Client form to save and refreshing the combo box on the calling form but it just isn't playing the game.
The calling form's control source is a query combining 3 tables and some lookup tables.
Any ideas out there? I could post some of the code if that helps.
Angelique
I get as far as opening the Client form, entering the details, closing the form and that's when the problem starts, I keep getting a 2118 error then the "Text not in list" comes up even through I have added acDataErrContinue to avoid the message.
If I try to reenter the newly created client in the combo box, it just triggers the entire process again. As I said the only difference in the coding, it that I am calling the form instead of presenting an empty form for the user to enter as the form calling it doesn't need all of the info.
I tried forcing the Client form to save and refreshing the combo box on the calling form but it just isn't playing the game.
The calling form's control source is a query combining 3 tables and some lookup tables.
Any ideas out there? I could post some of the code if that helps.
Angelique