SQL in VBA code ?

S

SpookiePower

Is it possible to put SQL into the VBA code ?

I have tryed to put it into a lable and textbox like this -

label.caption = "Select......."
textbox.text = "Select....."

But it will not work.
 
M

Maurice

That way won't work because what would be the value you need? If you want one
value you have to specify it by retrieving it from a recordset. This could be
q query but than again you also could use a DLookup if it was only one
record(field) value

Maurice
 
Top