<div>
So what would be the syntax?<br />
<br />
StrSQL = Select( ........)<br />
DoCmd.RunSQL (strSQL) &nbsp; &nbsp;I expect Two fields from this. Say Field1 and Field2<br />
<br />
Var1 = Field1<br />
Var2 = Field2<br />
<br />
Will that do it?
</div>


So what would be the syntax?

StrSQL = Select( ........)
DoCmd.RunSQL (strSQL)    I expect Two fields from this. Say Field1 and Field2

Var1 = Field1
Var2 = Field2

Will that do it?

<div>
I used DLookUp once for each field I was looking for. It worked
</div>


I used DLookUp once for each field I was looking for. It worked

<div>
<div class="content wysiwyg-content">
Given:<br />
A table: tPricing<br />
A query: Select (DeliveryID, PricePeriodID) from tPricing Where (tPricing!DeliveryID = Forms!fPricing!DeliveryID AND tPricing!PricePeriodID = Forms!fPricing!PricePeriod<wbr />ID)<br />
<br />
I then want to save the query results (only 2 fields in one record are possible) in Variables that I can validate (e.g. Null). I do not want to save the same information twice!<br />
<br />
Is it doable? How, please?
</div>
</div>


Given:
A table: tPricing
A query: Select (DeliveryID, PricePeriodID) from tPricing Where (tPricing!DeliveryID = Forms!fPricing!DeliveryID AND tPricing!PricePeriodID = Forms!fPricing!PricePeriodID)

I then want to save the query results (only 2 fields in one record are possible) in Variables that I can validate (e.g. Null). I do not want to save the same information twice!

Is it doable? How, please?

How to run a SQL query code and store the results without opening a query?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

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.