combo box duplicates

[j3andc]

I am using a combo box to populate data. I have 6 records currently in the table and 3 of them are the same. The combo box is listing all 3 when I am trying to select a new one. I want the list to only show the duplicates one time. How do I do this?

Jim

 

[j3andc]

Control Source does list the correct field.

The combo box list updated only after I closed down the database and reopened it.

 

[bat17]

you probably need to add an event to requery the Combo box when you change record so that it gets the added value.

Private Sub Form_Current()
Me.MyCombo.Requery
End Sub

changing MyCombo for the name of your combo box.

HTH

Peter

 

[j3andc]

I am getting an error message stating that I must save the record first. Is there a way to update the record (save) when I hit the tab key or pick another field?

 

[bat17]

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord

Should do it but I thought that saved the record before the onCurrent event fired anyway.

Peter

 

[j3andc]

Private Sub Form_Current()
Me.MyCombo.Requery
End Sub

In the above, do I replace the word Form with the name of the Form?

 

[bat17]

nope, the me is OK as long as you are in the form module but you do need to change the MyCombo unless I struck lucky

 

[j3andc]

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord

I can not get this to work.

 

[bat17]

Do you have any other code running? I have just built a test form and it works fine, i cannot replicate your error msg

Peter

 

[j3andc]

Do I put it before or after the requery line?

 

[bat17]

it would go before the requery line but I did not need it in my test

Peter