<div>
I will surely appreciate it if you could take a look at one of my posts here and if you could assist - it will be great.<br />
In order to understand the question, please read the entire comments so far made...then download the sample db uploaded in the last thread and experiment it if you could.<br />
<br />
If you require additional information, please free to post a comment.<br />
<br />
<a href="https://www.experts-exchange.com/questions/22994963/Select-Case-Amendment.html" rel="ugc">https://www.experts-exchange.com/questions/22994963/Select-Case-Amendment.html</a><br />
<br />
Regards<br />
Bill
</div>


I will surely appreciate it if you could take a look at one of my posts here and if you could assist - it will be great.
In order to understand the question, please read the entire comments so far made...then download the sample db uploaded in the last thread and experiment it if you could.

If you require additional information, please free to post a comment.

https://www.experts-exchange.com/questions/22994963/Select-Case-Amendment.html [https://www.experts-exchange.com/questions/22994963/Select-Case-Amendment.html]

Regards
Bill

<div>
Leigh:<br />
Thanks for your assistance. I have some new questions pending release. If you could edit your profile with an e-mail, then I'll inform you of my new listings when they are listed. You could also drop me a note via my e-mail in my profile if you choose not to add e-mail to your profile.<br />
<br />
Regards<br />
Bill
</div>


Leigh:
Thanks for your assistance. I have some new questions pending release. If you could edit your profile with an e-mail, then I'll inform you of my new listings when they are listed. You could also drop me a note via my e-mail in my profile if you choose not to add e-mail to your profile.

Regards
Bill

<div>
<div class="content wysiwyg-content">
I will like to modify the RowSource Query below to read:<br />
....WHERE tblConnSize.ConnSizeType is between 1.0 To 2.0<br />
<br />
I tried the one below but did not work<br />
<br />
cboConnSize.RowSource = &quot;SELECT [tblConnSize].[ConnSizeID]<wbr />, [tblConnSize].[ConnSizeTyp<wbr />e], [tblConnSize].[ConnSize] FROM tblConnSize where tblconnsize.connsizetype 1.0 To &nbsp;2; &quot;<br />
&nbsp; &nbsp; cboConnSize.Requery<br />

</div>
</div>


I will like to modify the RowSource Query below to read:
....WHERE tblConnSize.ConnSizeType is between 1.0 To 2.0

I tried the one below but did not work

cboConnSize.RowSource = "SELECT [tblConnSize].[ConnSizeID], [tblConnSize].[ConnSizeType], [tblConnSize].[ConnSize] FROM tblConnSize where tblconnsize.connsizetype 1.0 To  2; "
    cboConnSize.Requery


RowSource Question

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.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.