find record from field in subform and then return its parent record

[gmc2k2]

Hi,

i have a database which has a main form and subform built in linked by parent/child customerid, what i would like to do is search all the subform records from the whole DB and return its parent record on the main form?

can this be done? because if i use find it will only search the filtered form i have onload of the form?

my onload event is based on fosusername()

any help appreciated

 

[gmc2k2]

any help on this would be really appreciated

 

[JHB]

Could you show some sample data in an Excel sheet or a database + a print screen how you want the result, (zip it).

 

[gemma-the-husky]

you cannot do this from the subform.

the subform is dependent on items in the main form, so clearly you won't have any other items in the subform dataset.


you could however use an area of the mainform to manage some unbound fields to give you a general search facility - to get at the main form record you want - or you could open another form to interrogate and pinpont the record you want.

once you have the recorded, you can search/find the desired record on the main form.