SQL in VBA code ?

  • Thread starter Thread starter SpookiePower
  • Start date Start date
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.
 
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
 
Back
Top