Combo Box Question

[buck]

Hi,



I have a combo box on a form with claim #s. When selecting a claim # the appropriate record displays, but when using the record selector to advance to the next record, the combo selection does not update. Is there a way to correct this please?

[orange]

The combo will have a rowsource which identifies the records and the order of those records in the combo.

If you are processing records in some sort of loop, then movenext (unless you're at EOF) should get you the next record.

What "record selector are you referring to"?

[buck]

By way of the standard record selector in Properties that allows advancing forward and backward.

[orange]

What is the rowsource of your combo?
What is the recordsource of the Form?

[buck]

both are the same table

[buck]

this is what needed to be done; I pulled this from a previous database of mine.

Private Sub Form_Current()
Combo99 = Claim_Prefix

End Sub

[orange]

How about showing us the details (query SQL) of
-the Form's recordsource and
-the Combo Rowsource (query or value list)

Note: Just reopened this forum and see your post is Solved?

[buck]

as I mentioned earlier, the form's source is a table and the combo is also the same table; the unique ID is the claim #

[orange]

There is no inherent Order in a Table. If you want records to be in a specific Order, you must use a Query with an Order By clause.

[buck]

I think my initial inquiry was misread, I was not asking for a specific order, I was asking how to code so the combo values would match the form value when using the record selector to advance to the next record. The OnCurrent code that I posted does this. So I'm good. Thanks.

[ItsMe]

Hi,

I have a combo box on a form with claim #s. When selecting a claim # the appropriate record displays, but when using the record selector to advance to the next record, the combo selection does not update. Is there a way to correct this please?

I don't think I have ever associated a combo with a form's On Current event. I have associated combos with On Load events when a form opens to a specific record and the form's navigation buttons are disabled.

I use combos to help with user input and not to display info that I would normally use a subform for.

[buck]

cbo are good for multiple purposes, I've always used them to display accounts by selection, I prefer to have the form open blank and then make a selection, etc., works well. The OnCurrent event is one I've used for several years . . . just forgot about it. Have a good day.