Hi,
I have a database that is tracking customer details. There is a form with summary customer information (split form with only the datasheet view visible) and double-clicking on their ID brings you into a detail page with generic information on the form and then a Navigation Control that splits out the remaining data into Personal Data, Employment Data & Misc Data.
As the summary form is displaying the datasheet view there is a "New" value beneath the last record. I've set up the VBA so that when a user double-clicks on this they can set up a new customer.
Double clicking on existing customers works fine and all the correct data on all the Navigation Control tabs appears as expected. But when I try to add a new record I enter the generic information, click into the Navigation Control to add the Personal Data, then click into the other tabs to add the relevant info there.
The result I get is one record with the generic information, the Employment Data & the Misc Data and another record with simply the Personal Data. I've tried refreshing the control and the form but I always get an extra record. :banghead:
Has anyone any idea how I can stop this from happening!?
Thanks,
John.
I have a database that is tracking customer details. There is a form with summary customer information (split form with only the datasheet view visible) and double-clicking on their ID brings you into a detail page with generic information on the form and then a Navigation Control that splits out the remaining data into Personal Data, Employment Data & Misc Data.
As the summary form is displaying the datasheet view there is a "New" value beneath the last record. I've set up the VBA so that when a user double-clicks on this they can set up a new customer.
Double clicking on existing customers works fine and all the correct data on all the Navigation Control tabs appears as expected. But when I try to add a new record I enter the generic information, click into the Navigation Control to add the Personal Data, then click into the other tabs to add the relevant info there.
The result I get is one record with the generic information, the Employment Data & the Misc Data and another record with simply the Personal Data. I've tried refreshing the control and the form but I always get an extra record. :banghead:
Has anyone any idea how I can stop this from happening!?
Thanks,
John.
