Hello Everyone!
I'm very new to MS Access. I work for a charity organization. We offer free items to our clients. We have what are called "Personal Items" and "Community Closet Items". I am attempting to build a database that can track all of these give away's. I have created an order form. On this order form I would like to be able to add to the order record. When I attempt to do so I get the error "Field cannot be updated". I believe this is because the field is not bound correctly but unfortunately I have not been able to figure out how to bind it properly. I have been able to make this field a combo box with only the options from the item list table however when selecting from the combo box I get the same error.
For the end result I would like to have a combo box on the subforms of the order form that has a list of items to select from (this list will originate from the item list table and show the name of the item not the primary key or item ID). Once an item is selected a quantity can be entered and this will add to the current client order record.
Here are my relationships:
(Please see attachments I have less than 10 post and cannot post links yet)
Here is what my order form looks like currently (I have reverted back from the combo box for now):
(Please see attachments I have less than 10 post and cannot post links yet)
The orders for the customer shown at the top show up on the left. When selecting a date on the left the order details show up on the right. This order form has 3 subforms. The main form is called "Order" the sub forms are "Shopping", "Personal Orders Subform", and "Community Closet Orders Subform".
Here is a link to the entire database:
(Please see attachments I have less than 10 post and cannot post links yet)
Thank you in advance. I would be happy to supply any additional information needed.
Justin
I'm very new to MS Access. I work for a charity organization. We offer free items to our clients. We have what are called "Personal Items" and "Community Closet Items". I am attempting to build a database that can track all of these give away's. I have created an order form. On this order form I would like to be able to add to the order record. When I attempt to do so I get the error "Field cannot be updated". I believe this is because the field is not bound correctly but unfortunately I have not been able to figure out how to bind it properly. I have been able to make this field a combo box with only the options from the item list table however when selecting from the combo box I get the same error.
For the end result I would like to have a combo box on the subforms of the order form that has a list of items to select from (this list will originate from the item list table and show the name of the item not the primary key or item ID). Once an item is selected a quantity can be entered and this will add to the current client order record.
Here are my relationships:
(Please see attachments I have less than 10 post and cannot post links yet)
Here is what my order form looks like currently (I have reverted back from the combo box for now):
(Please see attachments I have less than 10 post and cannot post links yet)
The orders for the customer shown at the top show up on the left. When selecting a date on the left the order details show up on the right. This order form has 3 subforms. The main form is called "Order" the sub forms are "Shopping", "Personal Orders Subform", and "Community Closet Orders Subform".
Here is a link to the entire database:
(Please see attachments I have less than 10 post and cannot post links yet)
Thank you in advance. I would be happy to supply any additional information needed.
Justin