Add Record related is required

[firewall_ie]

hi all,

I am getting an error message "you cannot add or change a record because a related record is required in table 'personal details'.

What is happening is I have a main client form with command buttons that run other related froms that store information on client details such as attendance. When trying to save the form I get the above error. Any ideas anyone.

Regards

AB

 

[Oldsoftboss]

Have a look in your table design. The field that is giving you trouble will have its required property set to yes.
HTH
Dave

 

[firewall_ie]

Thanks buddy that help me solve it, there was a relationship between tables that was interferring with VB code that was runnning. So I removed the relationship and that solved it

 

[Oldsoftboss]

Good Stuff