DATA ENTRY FORM TO BE STORED IN A TABLE

[LMHODNETT]

I have 3 tables that are used in my database. Two are imported from an inventory program we use that sets up a customer table and an sku table. There is a third table for employees names. I have a form for data entry that will be used as a special order form for our store. The problem I am having is a fourth table that will be the special order table which will be fed by the special order form. I cannot get the table to fill with the data I am putting into the form. When I use a combo box in the form, say for customer name, phone address, zip and etc., the data is not stored in the table. I have the same problem with the pattern to order. The data comes from the sku table, but does not store in the orders table as pattern, vendor sku#, retail and etc. Getting the orders table to store this data does not sound hard to me, but, I have been unable to get it ot work after many weeks of trying. Does anyone have an idea of how I can this task done??

Thanks,
Larry

 

[hermanlaksko]

Well if data i entred into a tabel it is registred.

However if the database is readonly, nothing is ofcourse registred, readonly can occour on different levels:
1. The file itself (the mdb) is set to readonly. (attributes)
2. User rights on a given server.

Also preventing data insertion into a table can be conflicting keys, index set to no dublicates and a new key is not provided.
Chk this and let us know.

Herman
Say no to macros