Combo box selection not working

[Ina]

I have a form with two subforms running from a one to many relationship query.
The subforms open on a new record.
In each subform I have a combobox to select the test I want to add.
It comes up with the list of tests but wouldn't let me choose one.


I'm at the point where I don't know how to fix this and do appreciate any help, please!
Attached is a copy of my db file.
Thank you in advance 🙂

[CJ_London]

some instructions as to which form is an issue will be helpful.

[June7]

What is name of form need to look at? And name of combobox?

[Ina]

Sorry, about that.
The form name is "DNAProfileAddF"

[June7]

There is no form with that name.

[Ina]

Sorry, I attached the wrong file.
This is the correct one.

[June7]

Not surprising unable to make selection in any of those comboboxes with such complex RecordSource, which is apparently a non-editable dataset. Normally a form is intended to enter/edit data for one table. Why do you have such a complex query chain to produce dataset for these subforms? Suggest you reexamine and simplify. Too much for me to try to understand and unsnarl that query chain.

[orange]

@Ina,

Might be a good strategy to tells what your issues are and how to repeat/experience specific issues.

Also, recommend you establish relationships between your tables; enforce referential integrity to take advantage of built in database features.

[Ina]

@Ina,

Might be a good strategy to tells what your issues are and how to repeat/experience specific issues.

Also, recommend you establish relationships between your tables; enforce referential integrity to take advantage of built in database features.

Hi Orange, are you willing to take a look at my whole database and help me to get it right?
My frontend is 50mb large so I will have to share a location on my One Drive.

[June7]

Decided to play around with. What I did:

1. set DNADiseaseAddSubF RecordSource to DNAProfileT

2. add ShortDescription to Combo10 RowSource, change ColumnCount to 3, change ColumnWidths to 0";1.875";0"

3. set ShortDescription textbox ControlSource to =Combo10.Column(2)

Now do same for DNATraitsAddSubF.

[orange]

I've been away for Christmas--now I see this is Solved?? What exactly was the solution, it may help someone else.