HELP Subform is producing multiple records

[VeganLiving]

Hello,



I am having a problem with my subform that is populated when a value is clicked on a combobox in the main form.
I have the code in each text box in the subform correctly to pull the correct field that is hidden in the combo box.
Example:
=[Forms]![Data Dictionary-Look up Business Name]![cboTECH].[Column](5)

When go to Form View and chose a value from the combo box the subform shows the right records A MILLION times (well not a million). I have many subforms in my Forms so I didn't do anything different when creating this one. PLEASE HELP.

[June7]

Probably because the subform has a RecordSource that is a query joining several 'many' tables. Post the sql statement of subform RecordSource.

[VeganLiving]

I'm using a view that was created for my display forms. So it's only 1 table that I'm using.
In the subform Record Source this is my SQL:
SELECT NEXTGENERA_V_CMB_METAFIELDS2.DB_SCH, NEXTGENERA_V_CMB_METAFIELDS2.DB_OBJ_NAME, NEXTGENERA_V_CMB_METAFIELDS2.DB_COL_NAME, NEXTGENERA_V_CMB_METAFIELDS2.DATA_TYPE, NEXTGENERA_V_CMB_METAFIELDS2.DATA_LENGTH
FROM NEXTGENERA_V_CMB_METAFIELDS2;

I did try to change the Record Source to just the table name and it didn't make a different.
I also have only 1 Master/Child fields because when I try and add multiple fields it does not show any records in my subform.

[June7]

So the issue is with the Master/Child linking because requires a compound primary/foreign key to establish unique identifier? What is the main form RecordSource?

Is this form/subform used for data entry/edit?

If you want to provide db for analysis, follow instructions at bottom of my post.

[VeganLiving]

The record source for the Main Form is :
NEXTGENERA_V_CMB_METAFIELDS2

This is just a data dictionary that displays table information. No edit/delete/add.

[June7]

So the main form and the subform have the same data source. Why?

Options I would go with:

1. one form in continuous view and put the filter inputs in form header

2. do not link the main form and subform and apply filter to the subform dataset

BTW, I hope those controls used to input filter criteria are UNBOUND.

[VeganLiving]

I wish I could use a continuous form but my manager wants the forms to look a certain way.
As for the linking the subform and the main form I have removed the Master/Child links and i'm still having the issue.

Here is what is coded in the subform text boxes.

[June7]

Controls can be arranged on continuous form to look much like a datasheet.

I don't understand textboxes in subform referencing main form combobox columns. Of course those values will display on every record of the subform and appear as 'duplicates'.