jonnyboy101
Registered User.
- Local time
- Today, 00:12
- Joined
- Dec 4, 2013
- Messages
- 15
Hi All,
I have a form in which the user selects a combobox and this value becomes a tempvar called "un" on clicking a command button I need the value of "un" to be passed into a table.
"un" is a number.
Here is what I have so far.....
but seem to get syntax errors all the time. Hope someone can help. Jon
I have a form in which the user selects a combobox and this value becomes a tempvar called "un" on clicking a command button I need the value of "un" to be passed into a table.
"un" is a number.
Here is what I have so far.....
Code:
CurrentDb.Execute "INSERT INTO timedata(startedby) " & _
" VALUES(" & TempVars!un & ")"
but seem to get syntax errors all the time. Hope someone can help. Jon