Search results

Hi, I have created a form that searches a table to show certain criteria. I am having trouble with a part where the table uses a checkbox and I am trying to use a combo box on the search form to return the results based on is it checked? Yes/No or both. When I test it I keep getting Runtime...

Hi GinaWhipp, You can probably tell from my question that I am a rank amateur! That link explains it perfectly for me so thanks for the info. Thanks also for the advice regarding Reserved Words. Rob

Hi, I am trying to create a query where a user will enter information in boxes (any combination) on a form and a query will bring up the joined information from 4 different tables but I do not know where to start with the relationships on the query let alone the best method to search. I would...

Hi, I have now managed to achieve what I was intending thanks to both of your help. If I could push for a little more help it would be appreciated. I have six unbound text boxes which when I fill with information and run my search query returns the results in a table. If I leave a box blank...

Thanks Paul. That puts me a lot closer to what I want. What I am looking to do is have four text boxes attached to fields (i.e. Customer, Brand, Product, Date) and be able to type in each box to filter down the results to rows matching those four bits of information. Thanks Rob

Hi, I want to enter text boxes on a form that are linked to certain fields on a table and when search criteria is typed in show the results in a table on a subform. Can anyone help me with this? Unfortunately I am very inexperienced with this type of thing so what may be a very simple...

Hi, I'm an absolute beginner on access and need some help with putting a search button on a form on my database. On the navigation buttons at the base of the form there is a search facility where I can type a record id but I would like to get rid of that and search records either by turning...