Insert Into

[maniaouri]

I have a very simple question to make:

how I insert into a table or a query the value of textbox or a combobox.I want to use the insert into command. I tried to type the name of the control but it produces the insert value message.

I know the syntax if I write the value in the code but not if Ihave to use a combobox

example:

DoCmd.RunSQL "INSERT INTO [Material category] ( [Material category] ) values (=me.Text6);"

What do I do wrong?

 

[Dennisk]

do it like this

DoCmd.RunSQL "INSERT INTO [Material category] ( [Material category] ) values (" & me.Text6 & ");"

 

[maniaouri]

I tried it and it says enter parameter value. I want to do it automatically when i enter the value in the textbox or combobox.