Record select using a combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MeSteve - 04 Feb 2008 16:04 GMT

I have a form that uses a combo box to select the record displayed. When the
form is opened, the first record is displayed, but the combo box is empty.
Is there a way to populate the combo box to match the record displayed upon
opening the form?

Reply to this Message

Klatuu - 04 Feb 2008 16:51 GMT

In the form Load event:

Me.MyCombo = Me.SomeControl

SomeControl would be the control bound to the field you want to match on.

Signature

Dave Hargis, Microsoft Access MVP

> I have a form that uses a combo box to select the record displayed. When the
> form is opened, the first record is displayed, but the combo box is empty.
> Is there a way to populate the combo box to match the record displayed upon
> opening the form?

Reply to this Message

MeSteve - 04 Feb 2008 18:09 GMT

Works great. What event would fire on record change, such as selecting a new
record via scroll wheel?

> In the form Load event:
>
[quoted text clipped - 6 lines]
> > Is there a way to populate the combo box to match the record displayed upon
> > opening the form?

Reply to this Message

Klatuu - 04 Feb 2008 18:27 GMT

The Form Current event fires on each record change including the first. If
you want to sync your combo on every record, take it out of the Load event
and move it to the Current event.

Signature

Dave Hargis, Microsoft Access MVP

> Works great. What event would fire on record change, such as selecting a new
> record via scroll wheel?
[quoted text clipped - 9 lines]
> > > Is there a way to populate the combo box to match the record displayed upon
> > > opening the form?

Reply to this Message