MushroomKing
Registered User.
- Local time
- Yesterday, 18:47
- Joined
- Jun 7, 2018
- Messages
- 100
Hi guys!
Small question here I cant seem to find any answer for.
Maybe im searching with the wrong terminology?
I would like to use a variable to adres a table in my SQL bit inside my VBA code.
What I try to do is this:
Is it even possible to have a string to adres a table???
(see bold text).
Would be great if i could...Thanks in advance guys!
Small question here I cant seem to find any answer for.
Maybe im searching with the wrong terminology?
I would like to use a variable to adres a table in my SQL bit inside my VBA code.
What I try to do is this:
Code:
Dim db As Database
Dim rec As Recordset
Dim ToControlString As String
ToControlString = Me.fieldname23
Set db = CurrentDb
[B] Set rec = db.OpenRecordset("Select * FROM ToControlString ")[/B]
Is it even possible to have a string to adres a table???
(see bold text).
Would be great if i could...Thanks in advance guys!