Report generates ID instead of field name

[jj1]

Problem persist because I cant change bound column property in Main form for rootcauses to 2 which is text value because I need to have dynamic combo box So, IF i change the value to 2 text values of dynamic combo box countermeasure stops populating.



Countermeasure gets values as per the selections in root cause

Now build query that includes Main, RootCause, Countermeasure tables. Use join type "Include all records from Main ..."

[June7]

Why are you trying to change the combobox?

Did you try the query I suggested for the report?

If you now want to save the text into Main, the comboboxes can still be dependent but requires changing a few things, not just the BoundColumn property.

[jj1]

Yes I tried the query Here it is

SELECT tblMainTWTTPSheet.txtRootCause, Count(tblMainTWTTPSheet.txtRootCause) AS CountOftxtRootCause
FROM HERCARootCauseCMOptionsT RIGHT JOIN tblMainTWTTPSheet ON HERCARootCauseCMOptionsT.intHERCARootCauseID = tblMainTWTTPSheet.atnHERCARootCauseID
GROUP BY tblMainTWTTPSheet.txtRootCause;


I changed the combo box property in main table to text box (Look up) no changes in the combo box on main form

what other properties I have to change to save text in main table instead of ID



I am attaching a screen shot of properties please see

[June7]

If you want to show the text value in that query then need to pull in the text field from RootCause table, not the field from Main table.

If you want to save text into Main table:

Make sure field is text type (might be an issue changing type if Access insists there are established relationships). Then if you have real data need to correct the existing entries in records.

Combobox properties:

RowSource: SELECT txtRootCause, atnHERCARootCauseID FROM HERCARootCauseTypesT;
ControlSource: txtRootCause (field in Main table)
BoundColumn: 1
ColumnCount: 2
ColumnWidths: 1";0"

Is CounterMeasure combobox dependent on RootCause combobox? What is name of table that associates RootCause and CounterMeasure? The RowSource for CounterMeasure would reference ID from RootCause combobox. Column index begins with 0:

SELECT txtCounterMeasure FROM tablename WHERE RootCauseID = [RootCause comboboxname].[Column](1);

[jj1]

Yes Countermeasure combo box is dependent on rootcause combo box. The table that associates RootCause and CounterMeasure is HERCAcountermeasureCMOptionsT

If you want to show the text value in that query then need to pull in the text field from RootCause table, not the field from Main table.

If you want to save text into Main table:

Make sure field is text type (might be an issue changing type if Access insists there are established relationships). Then if you have real data need to correct the existing entries in records.

Combobox properties:

RowSource: SELECT txtRootCause, atnHERCARootCauseID FROM HERCARootCauseTypesT;
ControlSource: txtRootCause (field in Main table)
BoundColumn: 1
ColumnCount: 2
ColumnWidths: 1";0"

Is CounterMeasure combobox dependent on RootCause combobox? What is name of table that associates RootCause and CounterMeasure? The RowSource for CounterMeasure would reference ID from RootCause combobox. Column index begins with 0:

SELECT txtCounterMeasure FROM tablename WHERE RootCauseID = [RootCause comboboxname].[Column](1);

[June7]

So did you decide to go with changing the structure to save text instead of ID? Did it work?