Adding a Textbox to a query 1

[Xenocide]

Hi

I'm trying to make a query that will go take some information in a textbox and a combobox in a form

Here's my string

INSERT INTO [C:\Documents and Settings\schiasson\Bureau\Stuff\BDTest].Depense ( Maitre, Depense )
SELECT Formulaire1.cbo1.value AS Expr1,Formulaire1.txt2.value AS Expr2;

it's not working. I tried a few thing but I can't find the way to make it work.

Most of the time new window pop up asking for the information. That's not what I want

Thanks for yur help

 

[PHV]

INSERT INTO ...
VALUES ([Forms]![Formulaire1]!cbo1,[Forms]![Formulaire1]!txt2)

Obviously Formulaire1 must be an opened main form when this append query is launched.
Bonne chance.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Xenocide]

Merci

It worked perfectly