is it possible to insert dynamic values into a table via a form?

[hbutt]

i wanted to take dynamic values from a form and insert them into a table. i tried to create a query that would allow me to do this via the form, i havent been able to do so.
i wanted to know if this was possible and using a pk var that is of auto number type.
any help is much appreciated.

 

[ZmrAbdulla]

BoundForm? UnboundForm?
Also pls provide some more details about what you want to do.

________________________________________
Zameer Abdulla
Visit Me
Hold your child's hand every chance you get.
A time will come when he or she won't let you.

 

[hbutt]

the form field values i want to enter into the database table are the same as the table fields.

the query i thought about using for this is similar to this, i dont know if it is correct at all.

INSERT INTO CustomerDetails
VALUES (Cust_ID, CompanyName, Forename, Surname, HouseNo, Address, City, County, PostCode, Telephone, Mobile);

does this help at all?

 

[ZmrAbdulla]

Still not answered Bound/Unbound!!
If unbound see See Thread702-1030355

________________________________________
Zameer Abdulla
Visit Me
Hold your child's hand every chance you get.
A time will come when he or she won't let you.