Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-02-2018, 11:38 AM   #1
JJHeck
Newly Registered User
 
Join Date: May 2018
Posts: 2
Thanks: 2
Thanked 0 Times in 0 Posts
JJHeck is on a distinguished road
Exclamation Subform Data Entry via Combo Box

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
Attached Images
File Type: png Order Form.PNG (35.3 KB, 27 views)
File Type: png Relationships.PNG (36.6 KB, 25 views)
Attached Files
File Type: accdb Community Closet - Copy.accdb (1.12 MB, 23 views)

JJHeck is offline   Reply With Quote
Old 05-02-2018, 01:55 PM   #2
bob fitz
AWF VIP
 
Join Date: May 2011
Location: Essex England
Posts: 3,531
Thanks: 52
Thanked 684 Times in 666 Posts
bob fitz has a spectacular aura about bob fitz has a spectacular aura about bob fitz has a spectacular aura about
Re: Subform Data Entry via Combo Box

I would combine both the Order tables into one table. That said I have made some changes to your exiting db to show how to get one of the subforms (Personal Items Orders) to work. Post back if you need explanations.
Attached Files
File Type: zip Community Closet Bob01.zip (140.9 KB, 28 views)
__________________
Bob Fitzpatrick
Microsoft Community Contributor Award (2011)
If this helped, please click the scales at the bottom left of this posting.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Many thanks.


I have never failed. I have found a thousand ways that do not work!
bob fitz is offline   Reply With Quote
The Following User Says Thank You to bob fitz For This Useful Post:
JJHeck (05-16-2018)
Old 05-02-2018, 11:33 PM   #3
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,568
Thanks: 68
Thanked 2,744 Times in 2,629 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Subform Data Entry via Combo Box

If same as bob just ignore.
Attached Files
File Type: zip Community Closet - Copy.zip (79.6 KB, 17 views)

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
JJHeck (05-16-2018)
Old 05-16-2018, 12:47 PM   #4
JJHeck
Newly Registered User
 
Join Date: May 2018
Posts: 2
Thanks: 2
Thanked 0 Times in 0 Posts
JJHeck is on a distinguished road
Smile Re: Subform Data Entry via Combo Box

Bob Fitz,

That was exactly what I was looking to accomplish!

Thank you so much!


arnelgp,

Thank you as well! Perfect!

JJHeck is offline   Reply With Quote
Reply

Tags
combo box , subform combo box , subform data entry

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
data entry with combo box DRgal Forms 4 04-01-2014 12:43 AM
Please Help: Populating subform with combo box +text field entry sparkyboy2406 Forms 3 02-16-2010 06:05 AM
combo+combo+subform... data entry haftepeek Forms 1 07-04-2007 05:58 AM
Subform Blues - Data Entry setting itself to 'No' & Requerying 1 subform from another Keith Nichols Forms 10 12-11-2006 06:56 AM
New data entry from combo box DarkProdigy Forms 53 07-31-2006 03:22 PM




All times are GMT -8. The time now is 09:12 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World