Combo Box Unique Value Error on Tab

[cardgunner]

I created a form and in the form I placed a combo box. I set the row source to a query built of a single table. Bound Column =1. Column Count=5. Column Widths = 0",1", 1", 1", 1". List Wdth=4". Column main.id, main.search, main.c_name, main_add1, main_state.

In Form view I select the record I'm looking for and tab. After tab I get an error stating "Changes to the table was not successful because it would create duplicate records..."

I don't get it.

This is in Access 2007.

Any help is appreciated.

 

[pbaldy]

If you're using the combo to find records, it should not be bound to the table (it shouldn't have a control source). Is it?

 

[cardgunner]

It is for searching purposes. the control source is main.id.

 

[pbaldy]

Is this clearer?

it shouldn't have a control source

 

[cardgunner]

I guess I need to do some research then becasue now I'm uncertain how to get my subforms to link to this. Was I able to do this in Access 2003. It's been a long time but I thought I do this before.

 

[cardgunner]

Well I added the subform and linked it up but uncertain on how that worked.

In anycase thanks for your solution.

 

[pbaldy]

No problem. You can still use the master/child links, but you have to manually specify the combo.