INSERT query using a Form text box

[DonkeyKong]

I'm sure that this question has been asked before, but my google searches and forum searches weren't coming up with what I was looking for.

I would like to add values to tables from values entered into text boxes on a Form using only sql, if possible.

Can I reference a textbox name in SQL? so something like...

INSERT INTO RESIDENTIAL_CUSTOMER(CUS_FNAME)
VALUES (CustFN.NEW_APPOINTMENT);

where CustFN is the name of a textBox in the NEW_APPOINTMENT Form and RESIDENTIAL_CUSTOMER is the table, CUS_FNAME is the attribute.

Thanks.

 

[pbaldy]

Here's the syntax to refer to the form:

http://www.mvps.org/access/forms/frm0031.htm

You want the full syntax, not the Me shortcut.