Searching Subform from Mainform Combobox

[Padstar]

Hi Folks, I am trying to make a form in my DB that will allow me to search on it's subform for a serial number and bring up the relevant recordset to the main form.

I have a basic asset database, main form Primary index is ticketref, Subform Primary key is SerialNo.
Main form holds details of Ticket Number, User and Order date as well as notes, subform holds the hardware details, serial nmber make model etc.

I want to be able to click on the combo box and type in a serial number from the main form and have it display the relvant details to the main form. Hope this makes sense...

Cheers



Pad

[June7]

Subforms do not control main form (children do not dictate parents).

Are Master/Child links properties of the subform container set? If so, then not all serial numbers and ticketrefs are available in the subform.

Code could take the serial number input, search table (use DLookup) for associated ticketref then apply ticketref filter to main form. The related records in subform will synchronize by the Master/Child links.