ComboBox to search subform and allow data entry

[lizymmm]

Hello,

I am trying to create a combo box in the main table that allows me to search and select, bringing up related records in my subform.

When I have made a combobox using the wizard, it has all the values from the field and you are able to search through and select. However, the subform is 'untouchable'. If you try to click anywhere in it the following error message appears 'the record cannot be deleted or changed because the table 'X' includes related records'. This is not when I try to delete or add it simply appears when trying to click on any part of the subform.

I need to be able to edit the subform as this is where I would be adding new records.

Thank you for any help.

 

[lizymmm]

It also will not allow me to go back to design view, I have to close and not save the whole thing in order to stop the error message (basically revert back to no combo box).

 

[lizymmm]

The record cannot be deleted or changed because table <name> includes related records. (Error 3200)Access Help says: The record cannot be deleted or changed because table <name> includes related records. (Error 3200)

You tried to perform an operation that would have violated referential integrity rules for related tables. For example, this error occurs if you try to delete or change a record in the "one" table in a one-to-many relationship when there are related records in the "many" table.
If you want to delete or change the record, first delete the related records from the "many" table.

The "one" table of mine must refer to the field in the combobox. I don't understand this message because I am not trying to change any records in this field, just use them to search.

 

[boblarson]

1. You should NOT be using lookups (i.e. the combo box) at TABLE level. See here for why.

2. You create combo's on FORMS to use lookups - not in tables.

 

[lizymmm]

Thank you for the reply!