Search results

I have a similar problem to a couple of other threads I have found, however I do not seem to be able to find a solution. There is a combo box in the form header which brings up the corresponding record in the detail. I then have a text box (lets call it text box 1) which pulls through a...

I wonder if anyone can enlighten me. If I have a table say with two fields Member and staff code: Member..... Staff Code Jon.................1 Adam.............10 Sarah.............7 Bob................8 If I also have a form with various details including a dropdown box for the member...

Following on from an earlier post, I thought I would ask a bit of further advice as I need a quick answer to this problem. The query in my database seems to be returning all of the fields rather than just selecting those which match the criteria selected from dropdowns in a form. I have...

Please could someone help with the following. I am trying to get my query to work from a set of criteria set by drop downs in a form. I want it to work if any of the drop downs is left blank (null values). If any one of the drop down criteria is incorrect (i.e. no exact match) no records will...

Please will someone help me with getting the correct results from my query using combo boxes in a form. I have set up a basic example with three query fields (ID, city, country). The combo boxes point to the table containg the same info (named: tbltrippy1). Query called: Qrytrippy2 and Form...