Sub Form help please

[johnob]

Hi all,

On the attached sample db , I have a few problems.

1) How do you get the main form ( RequestForm ) to save the data in the subforms.

2) When adding a new record , it keeps the data from the first record, also when changing the data on the second record, it changes the information on the first record.

3) How do you add a new line in Boxed section, so that i can make more entries

Thank you

 

[burrina]

You have some issues in your db. Naming conventions and table relationships.
tblCustomer
frmCustomer
Phone No ' Remove spaces.
Shows ' Name is a reserved word in Access.
That said, maybe this will help. I am unsure of your Schema so it's a stab in the dark.


HTH

 

[johnob]

Got most if it solved,

Just keep getting error

Index or primary key cannot contain a Null value

How can i fix this ?

Thank you

 

[burrina]

This happens when, doing what and on what?

 

[johnob]

Fixed now,

Thank you for your help