Search in a subform for record

[saira78]

I am having trouble with the find command button (probably because I'm a novice at Access).

In any case, what I am trying to accomplish is searching for a detail record in a subform (header form is the main form) which may have multiple header and/or detail records.

It is a normalized structure with a header record and multiple detail records for each header record.

E.g. I want to see all records that occur for item #19000.

How do I accomplish this in a form?

Thanks,
Saira

 

[jimb0ne]

when you open the form set the wherecondition argument of the method to something like "ItemNumber = " & variable

variable being the actual variable which contains the item number you want to view records for, and ItemNumber being the fieldname which store the item number.