hi,
i need some help with my database, i'm trying to search a subform and return its parent record. i have my DB setup as a main form and subform which is linked. the main form contains a customers type form and the subform (in datasheet view) contains their products.
what i would like is to be able to do is search the subforms table using a reference number field and return the parents record on the customer form to show the customer it belongs to if that makes sense?
how would i do this? as the subform is obviously filtered based on the parent child relationship.
any help would be appreciated? i did read somewhere the .findfirst method? but i didnt understand it fully.
i need some help with my database, i'm trying to search a subform and return its parent record. i have my DB setup as a main form and subform which is linked. the main form contains a customers type form and the subform (in datasheet view) contains their products.
what i would like is to be able to do is search the subforms table using a reference number field and return the parents record on the customer form to show the customer it belongs to if that makes sense?
how would i do this? as the subform is obviously filtered based on the parent child relationship.
any help would be appreciated? i did read somewhere the .findfirst method? but i didnt understand it fully.
