How to create a search box of subform

[swordspider]

I created a machine parts database. I created the form and the table I use a subform to display the records within the table. Now my problem is how I build the search box using textbox that can search a specific data within the subforms.

I'm new of data access I need more help. I appreciate any help from you sir...

[NeoPa]

There's a lot about this in Cascaded Form Filtering & Example Filtering on a Form.

Subforms make referencing a little more involved so Referring to Items on a Sub-Form may help.

[swordspider]

Hi NeoPa about this cascading I have no idea of this. What I did is I created a table query and I use it in subform in my main form called mpis. Now I use a macro using the apply filter in where conditions I created the formula like this [parts name] like "*" & [forms] ! [SEARCH DATA] ! [TEXT59] & "*" I copy paste this line to continue with the other field to search I use or to separate it. But this procedure not working. Thank you for the reply and the link you give me I will try to follow it.

[NeoPa]

I'll leave you to get on and find what you need then. It should all be there and available if you just look.

Cascading. Let me just explain what that means in this context so you can start to appreciate what it might be able to offer you.

ComboBoxes give you a list to select from. Simple enough. Sometimes though, a list can itself benefit from being filtered. Consider looking for a city in the world. I know countries differ in how they organise their internal structure. Here in the United Kingdom we have counties. In the USA they have states. Imagine then, a Form that allows you to select a city from anywhere in the world, but with a design to handle these two countries. There might be three ComboBoxes - cboCountry, cboCounty and cboCity. Once you've selected a country the list of counties is updated to reflect only those counties, or subdivisions if you prefer, from the selected country. If you then select one of the counties then cboCity gets updated to include only those cities within that county or state. This is cascading. Like a progression of waterfalls.

NB. I notice that the way you refer to Controls on your form is a very clumsy way so I suggest you review that after reading the article I linked to in my earlier post. In almost all cases the reference should start with Me..

[swordspider]

Hi sir ok thank you for that I need time to study it. I have many schedules so I can study this during my spare time. I will back here if I have other questions.

[NeoPa]

I look forward to more questions from you :-)