Combo Boxes for searching through forms

[Elizabeth Mitte]

I would like to produce a combo box that allows searching through records in a form so that new records can easily be added to the correct 'date' or 'id' for example.

When I have a combo box that is bound to a field in a table (and on the form) an error message appears saying 'the record cannot be deleted or changed because the table 'X' includes related records.'

This error message only appears when the combo box is on the form and linked to the field.

[beacon]

Hi Elizabeth,

I don't quite understand how you want to use the combo box, but I can explain the error message you're receiving.

The message, "the record cannot be deleted or changed because the table 'X' includes related records" means that you have setup a relationship between two tables and there are records that are related in both tables. The message implies that you are trying to delete a record that appears in the one side of a one-to-many relationship.

You can allow deletions across tables that have related records by going to Tools->Relationships, clicking on the relationship between the two tables in question, and selecting "Cascase Delete Related Records."

A word of warning though, if you choose this, as the name implies, it will delete all records that are associated with the record you are trying to delete.

So, if you have a client table (with a client ID field), an orders table (with an order ID field), and there a 50 orders associated with client ID #7, if you delete client ID #7 you will also delete all 50 of the orders associated with that client ID.

Hope this helps and good luck,
beacon

[Elizabeth Mitte]

The message appears without me selecting any record (i.e. it is not possible to select a record in the subform with the combo box present due to this error message), I am not trying to do anything when it appears!

I am trying to use the combo box to make data entry easier. So, for example, if you have new information on client 349 you are able to use the combo box to get to all the information on client 349 that is stored in the sub form.

Is this possible?

Thank you for replying!

[beacon]

Do you have any code behind the form/subforms? What is the record source for the form/subforms?

[Elizabeth Mitte]

Code?

The record sources are fields from tables. There is one table that is the main form with only one field with which I would like to have the combo box and search through the related records that hold all of the information stored in a different table, and shown in the subform.

Does that make sense?