Passing TempVar value into a table

[jonnyboy101]

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.....

        CurrentDb.Execute "INSERT INTO timedata(startedby) " & _
        " VALUES(" & TempVars!un & ")"

but seem to get syntax errors all the time. Hope someone can help. Jon

 

[David R]

Humor me, why is the field unbound if you're trying to store it in a table?

 

[jonnyboy101]

Because the user needs.to select their name and then another macro runs, then their name is passed to the table. Make sense?

 

[JHB]

What about, (I suppose timedata is the table name and startedby is the field name with the data type number and un is a variable name):

CurrentDb.Execute "INSERT INTO timedata (startedby) " & _ 
" VALUES(" & un & ")"

 

[Mihail]

Because the user needs.to select their name and then another macro runs, then their name is passed to the table. Make sense?

No.
I'm with David.

 

[jonnyboy101]

Thanks jhb, that worked a treat.

 

[JHB]

You're welcome, luck with your project.