SQL coding question

[ViperD]

I'm trying to write a sql statement. What I am trying to do is run a query when a field loses focus on a form. This field is in a subform. In my sql below, PatientSS# is the name of a TextBox.

DoCmd.RunSQL ("Select Claim_Type,Primary_Pymt from Tests where PatientSS#=" & PatientSS#)

I also want to know how I would assign the results of the query to an array.

 

[psemianonymous]

If you're running a select statement, I assume you want to look at the data. Do not use RunSQL, use CurrentDB.OpenRecordset(), or CurrentDB.Execute(), depending on whether you plan on using ADO or DAO recordsets.

Also, you will not be able to assign the query results to an array except for the hard way: row by row.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[ViperD]

I will want to look at the data while coding, but when the coding is finished, I will not need to seed the data. But the code will still need to run the select statement to get the data.

 

[ViperD]

I guess I should clarify my first post. VBA does not like my SQL statement. It tells me that there is a syntax error in date in query expression 'PatientSS#=0'. So I guess I need to know how I can reference a field on a form from within a subform on that form.