Validation Rule in Form

[mCool]

Hi guys

I am new to Access 2003 and I was trying to populate data onto a subform with a condition. The condition is that the data that is populated is limited to the same ID number as the ID number on the main form.

Can I do that via each textbox's validation rule or is there a simpler way ?

 

[John Big Booty]

First up welcome to the forum.

I'm not entirely sure I understand what it is you are trying to do.

A properly set up Form/Subform set will have a parent/child link via a unique ID on the main form which is stored as a foreign key in all child records. In this way all child records can be directly related to their parent.

Is that what you are trying to do? or are you trying to do something quite different

 

[MStef]

Look at "DemoSubA2000.mdb" (attachment, zip).
Open frmMain and see.
Adapt it in your mdb.

 

[mCool]

I found the answer. The reason it did not show what I wanted was because I did not populate the subform's table with different data. I have a r/ship btw the main form and the subform's table so it was all sorted automatically ! Thank you all so much for you time and advices !!!