Deleted record remaining in combo box

[davejackson]

Hi,

I have a subform which contains a combo box. The combo box selection moves the data on the subform to the selected record. A button on the subform deletes whichever record is selected at the time. I cannot get the deleted record to disappear from the combo box even though I am doing ComboName.Requery, SubFormName.Requery and Me.Requery - any requery i can think of in fact. The only way it disappears is when I move to a different record on the main form and then return. Can anyone offer any explanation or suggestion as to what I should do please.

Thanks in advance,

Dave

 

[braindead2]

me.refresh is what I usually use. refreshes the whole form

 

[davejackson]

Thanks for the reply, it does remove the record from the combo options but remains being displayed initially until you select something else. I'll keep bashing away.

Thanks again...

 

[JoeMiller]

After the me.refresh set the combo box to "" like this:

Me!SubFormName.Form!ComboBoxName = ""

HTH Joe Miller
joe.miller@flotech.net

 

[davejackson]

Thanks for the reply but I would like another record to be displayed, even if it is just the first record. It seems crazy to find the first record again but i guess i will...