search to including subform

[hishamaboualfa]

Hello guys,

basically i am new here and in access as well, my first inquiry regarding the attached simple form, i guess its self explanatory for what i am trying to do, the question is, usually the users of this form will search for records based on the invoice number and unfortunately the invoice number is located in the subform, so how i can facilitate to them to be able to locate the record easily, thanks in advance .

 

[llkhoutx]

Put a combo box control on the form with its data source being all the invoice numbers (in numerical/alphabetical order) for the instant Supplier or whatever drives the main form. Pick an invoice number in that combo box then set the subform "Filter" property to "[Invoice Number] ='" & me.cboInvoices & "'" and set the subform "FilterOn" property to True. If the invoice numbers are numeric, ignore the tic marks, strings must be enclosed with tic marks.

 

[hishamaboualfa]

thanks Boss for the reply, but it didnt solve the issue, I need to facilitate the search for the users to include the data in the subform or compobox

 

[Alvarogue]

Did you made the proper relationships between each form?