"SELECT" IN ACCESS

[REVBJONES]

By the way, you asked what I intend to do with the
results... I want to put the value of a field from
another table in a field on my current form based on
values (2) from fields on the form that has the focus...
(current form)

Bennie

-----Original Message-----

Hi,
Do you mean you want to open up a recordset?
What do you want to do with the results?

Dim strSql AS string
Dim rs As DAO.Recordset

strSql = "Select * From yourTable Where someTextField

= '" & Me.someControl & "'"