mpaulbattle
Registered User.
- Local time
- Yesterday, 22:28
- Joined
- Nov 30, 2017
- Messages
- 56
I created a data entry form to add a new provider. the form's record source is tblProviders.
1. Under the Data tab for form properties I changed Data Entry to Yes.
2. The On Load event I set the macro to open frmAddNewProvider with the gotorecord set to New
3. I added the fields for ProviderID,FN,LN,Credentials, Status, NPI, etc.
When I open the form and try to add a new provider I get a message that the changes were not successful because they would create duplicate values in the index, primarykey, or relationship. After looking at the form closely I noticed when I began typing in the new provider's first name the ProviderID that shows up is one that is already used. The ProviderID is an Autonumber field. The new record should be 601, instead it is starting at 520.
Does anyone know why this is happening?
1. Under the Data tab for form properties I changed Data Entry to Yes.
2. The On Load event I set the macro to open frmAddNewProvider with the gotorecord set to New
3. I added the fields for ProviderID,FN,LN,Credentials, Status, NPI, etc.
When I open the form and try to add a new provider I get a message that the changes were not successful because they would create duplicate values in the index, primarykey, or relationship. After looking at the form closely I noticed when I began typing in the new provider's first name the ProviderID that shows up is one that is already used. The ProviderID is an Autonumber field. The new record should be 601, instead it is starting at 520.
Does anyone know why this is happening?