How to use a combo box on a form

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.

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

Still confused... I dont see a combobox on the case information tab??

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"

<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?