Kiwiman
Registered User
- Local time
- Today, 07:55
- Joined
- Apr 27, 2008
- Messages
- 799
We have created a SQL Server back end that will hold all our Billing information that will be required for a new Billing engine. I have created an Access Front end to allow the users to enter the relevant contract information that is required.
The realtionships are:
tblContAttribHdr (one)
[PK] ContNo
tblContAttribLin (many)
[PK] ContNo
[PK] ContLineNo (auto increments by 1)
When entering a new record in, I can enter the header record and one line record, navigate away from the record then back to it, and the details are shown in the form. When entering a second record for the same contract, navigate to the first contract line then back to the second, the fields on the controls show "DELETED" for the new record. The data is actually written to the SQL server, but just not showing in the form.
The only way I can then view the "Deleted" record is to "Close" the form then reopen (or alternatively Requerying the form, when saving the record).
My question is I do not quite understand why the first record shows up without any problems, but the second record does not. And where how should I put the "Requery" code in the subform. I have included a save button on the subform, which has a requery expression, but I'm not sure if this is the best part.
Any thoughts \ help is much appreciated.
The realtionships are:
tblContAttribHdr (one)
[PK] ContNo
tblContAttribLin (many)
[PK] ContNo
[PK] ContLineNo (auto increments by 1)
When entering a new record in, I can enter the header record and one line record, navigate away from the record then back to it, and the details are shown in the form. When entering a second record for the same contract, navigate to the first contract line then back to the second, the fields on the controls show "DELETED" for the new record. The data is actually written to the SQL server, but just not showing in the form.
The only way I can then view the "Deleted" record is to "Close" the form then reopen (or alternatively Requerying the form, when saving the record).
My question is I do not quite understand why the first record shows up without any problems, but the second record does not. And where how should I put the "Requery" code in the subform. I have included a save button on the subform, which has a requery expression, but I'm not sure if this is the best part.
Any thoughts \ help is much appreciated.
