<div>
Not sure exactly what you need, but my Fancy Filters sample database might be helpful; it allows users to select values of various data types from combo boxes, and creates a filtered query, displaying the results in a subform. &nbsp;Here is the link for downloading it:<br />
<br />
<a href="http://www.helenfeddema.com/Files/accarch129.zip" rel="ugc">http://www.helenfeddema.com/Files/accarch129.zip</a><br />
<br />
and here is a screen shot of the form:<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/12_w49/886243/Fancy-Filters-Form.jpg" target="_blank" title="Fancy Filters form (150 KB)"><img alt="Fancy Filters form" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/12_w49/800_886243/Fancy-Filters-Form.jpg" /></a>
</div>


Not sure exactly what you need, but my Fancy Filters sample database might be helpful; it allows users to select values of various data types from combo boxes, and creates a filtered query, displaying the results in a subform.  Here is the link for downloading it:

http://www.helenfeddema.com/Files/accarch129.zip [http://www.helenfeddema.com/Files/accarch129.zip]

and here is a screen shot of the form:
Fancy Filters formhttps://filedb.experts-exchange.com/incoming/2014/12_w49/886243/Fancy-Filters-Form.jpg

Fancy-Filters-Form.jpg

<div>
Thanks for the advise. &nbsp;I'm going to use the built in Query Designer.
</div>


Thanks for the advise.  I'm going to use the built in Query Designer.

<div>
<div class="content wysiwyg-content">
Is there a way in Access to create a dynamic query form something like the attachment I've embedded?<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/12_w49/886180/Dynamic-Query-Form.jpg" target="_blank" title="Form example (47 KB)"><img alt="Form example" class="file-block lazyload" style="max-width: 586px;" data-src="https://filedb.experts-exchange.com/incoming/2014/12_w49/886180/Dynamic-Query-Form.jpg" /></a>
</div>
</div>


Dynamic-Query-Form.jpg

Is there a way in Access to create a dynamic query form something like the attachment I've embedded?



Create dynamic query form?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.