How to use a combo box on a form

SO i have attached a sample of my FE and BE databases. There is no sensitive data.  I am trying to use a combo box to select a value and have it stored in a table so I can use it later in a report but also have the value show up on the form.

The form is Case Details - page case information

the table I want the combo box to use is tblstatuscomments
the table I want the value to be stored in is tblcomments.  You will see that in tblcomments I want the PK from Tblclaims (invoiceId) to be also be stored so the linkage is there. Can someone help please
DMC-Backup-Backup.accdb
DMC-Backup-Backup-be.accdb
seamus9909Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
When attaching a database, please combine the front end and the back end into one file.  The FE contains links to the BE and in order for us to see how your database works, we must recreate these paths (or change them manually) on our own systems.

Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Remove any records unless they are relevant to the issue.
5. Delete any objects that do not relate directly to the issue.
6. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
7. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
8. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
9. Unhide any hidden database objects
10. Compile the code. (From the VBA code window, click: Debug-->Compile)
11. Run the compact/Repair utility.
12. Remove any Passwords and/or security.
13. If a form is involved in the issue, set the Modal and Popup properties to: No
    (Again, unless these properties are associated with the issue)
14. Post the explicit steps to replicate the issue.
15. Test the database before posting.

In other words, ...post a database that we can easily open and immediately see and/or troubleshoot the issue.
And if applicable, also include a clear graphical representation of the *Exact* results you are expecting, based on the sample data.
0
seamus9909Author Commented:
I apologize didn't know I had to do all those things.  I have done as directed

There is no sensitive data.  I am trying to use a combo box to select a value and have it stored in a table so I can use it later in a report but also have the value show up on the form.

The form is Case Details - page case information

the table I want the combo box to use is tblstatuscomments
the table I want the value to be stored in is tblcomments.  You will see that in tblcomments I want the PK from Tblclaims (invoiceId) to be also be stored so the linkage is there. Can someone help please

When the user selects a record from the Cases screen they are taken to the Case Details screen.


So what I would expect is a combo box to be in the Case Information page. That combo box should use the Tblstatuscomments as the source.  When the user selects one of the values, it would store that value,  Invoice ID (from Case Detailsform) and the comment in the tblcomments table. THis would be used later in a report I will want to write as well as each time the user would go back into the CAse Details screen that value would be displayed.

Thank you
DMC-Backup-Backup.accdb
0
Jeffrey CoachmanMIS LiasonCommented:
oK, I am looking at it now...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Jeffrey CoachmanMIS LiasonCommented:
Still confused... I dont see a combobox on the case information tab??
0
seamus9909Author Commented:
I was hoping you would show me how to create one!  Everytime I try to create one when I save the form and try and select a value it states "can not save dataset"
0
Jeffrey CoachmanMIS LiasonCommented:
<I am trying to use a combo box to select a value and have it stored in a table so I can use it later in a report but also have the value show up on the form.>
...Not sure I understand the need for this...

Combox fields are normally stored in the table, ...so I am not sure of what you are trying to do here...

Put a combobox on a blank tab, ... for what purpose?

Can you explain in a step by step process exactly what you want the user to do with this system and why?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.