I would like for the records for that value to appear in the main and sub form the seach for will be located in. I just want to be able to search by the subform as well as the Main form. You cant do that with the Find and Search box that Access provides you with
I have a form with a subform attached to it, the main forms record source is the Parent table and the Subform is the Child table both of course are linked (relational database). There is a total of 1562 Records in it, what I want to do is in the picture below theres a little form called Subjects_Form I want to be able to type anyone one of those fields and have the results appear in the main form, does that make sense??
No I'm going to get rid of the date of birth field and change it to IR number and yes that is my primary key. Can you explain a little further please how exactly how would I go about doing this?? "afterupdate events of your combo box, you could perform all of the attribute"