I checked the properties for the form and edit, delete, add, and data entry are all allowed. First of all, are you working in a "data integral" or in a Front End linked to a Back End type database?If the latter, then - I have found that Access sometimes has this sneaky tendency not to let you know whether or not your attachments to tables are up-to-date.Let's assume they've decided to continue and type something. Perhaps they can't remember the names of all the offices or they might make a typo. In fact with this method you don't even build a parameter query.Couldn't we add a combo box with a list of choices? You build a regular query that takes its criteria from a special form. This tutorial explains all of these steps in detail, so if you are already an experienced user you might want to skip straight to the bits that interest you.List boxes can offer the user the ability to choose more than one item, a property known as Multi Select.I am also going to allow the user to specify either "And" or "Or" conditions. The user makes their choices from the list boxes and option buttons and clicks the OK button to see the result.These properties let us know when we have reached the limits of a recordset.'For the purposes of this post, we are simply going to make 'str SQL equal to tbl Teachers.
In this blog post we will be demonstrating how to loop through a recordset.
David." id="ctl00_m_m_i_ctl00_gr_ctl07_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="2979866" / Paul, This will probably be the "dumbest" suggestion for a possible approach solution to your problem you get this week, but here goes anyway.
First of all, are you working in a "data integral" or in a Front End linked to a Back End type database?
The dialog box had combo boxes displaying criteria choices and when the user clicked a command button their choices were used to construct an SQL statement.
The SQL statement was then applied to a stored query and the user saw the result of their choices without having to get involved with query design. Instead of combo boxes I am going to use list boxes.