Find Parent form record base don subform search criteria

[Back2Basics]

Hi

I have a form with a subform. the form contains the following fields:

Customer
Site Reference
Area
Contact

The subform then displays all of the relevant items for that customer and site. So if a customer has 2 sites they will have 2 records in the parent form and each one will display the items relevant for either site. What I am hoping to do is to allow users to search on the 'Item_Ref' in the subform so that it will go to the customer record where that item reference is found. Item reference are unique, no item has the same reference as another.

Parent form name: frm_cus_full
subform name: sbfrm_item

The linked attribute is called Site_ID on both forms.



TIA

[aytee111]

The OnCurrent event of the subform occurs when you click on a row - at that point you can filter the main form based on the information of that row. Or you can use a button.

[ranman256]

you wouldnt search the subform, youd search the subform's data, the table.

a button on the form would open a param query.
this query would pull data from the subtable using the key in the parent table.
select * from subTable where [key]=forms!frmParent!txtKey and [field]=[enter search value]

[Back2Basics]

Thanks Ranman

I'm quite new to this so is it possible to fill in the details using my form and subform names?

Form: frm_cus_details
Subform: sbfrm_item
Field: Item_Ref

I'm not sure what 'subTable' and 'key' would refer to in your expression? Also, would I put this in the expression or the code builder? As I say, prey new to all of this.