Forms Does not save Record! (1 Viewer)

[mohamedatiya.access]

here in this data base i have 2 tables for p"ClaimsF" as Pop-upatients and Insurance Claims
I want to Add patient via "PatientAddF2" to be saved it to "PatientsT" then add claims via "ClaimsF" as Pop-up
the first thing i found
1 patient not show in "PatientsT" only if close MS Access And Reopen.
2 "ClaimsF" as Pop-up does not save The Added Claim.

username=4
password=0000

May I Have your Kind Advice

 

[June7]

I was able to exit PatientAddF2 without entering all data, even for fields set as required in table. That is odd. However, even when entering all required data, I get the issue you describe. That is also odd.

The n variable used in several events of this form makes no sense. If you want this variable to be read by several procedures of this module, it must be declared in module header. To be read by multiple modules it must be declared in a general module header.

Should use Option Explicit in every module header. Set this as default for new modules form the VBA editor > Tools > Options > Require variable declaration.

Should use code indenting to make it easier to read and understand.

 

[mohamedatiya.access]

Thanks for kind support! it's my first project
I have put a lot of effort - MORE TO COME - the odd thing also is that i have same copies of claim Adding forms "ClaimAddF4" and have same code and it woks fine!

 

[mike60smart]

I agree with June, I see no need whatsoever for the n variable

Also, what purpose do the following fields serve ??

ClaimSeriesLine
StaffSeriesLine
PatientSeriesLine
OrderSeriesLine