Sychronizing a combo box name to the form name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

G. Vaught - 27 Oct 2007 19:36 GMT

I swear as I get older, I get more forgetful. I've done this before, but its
been about five years since I used the code.

I have a lookup box on a form to choose a record. Howver when I use the
navigation arrows I want the the name in the combo to change when the record
changes. I checked Microsoft Knowledge Base and I looked briefly under the
two Forms newsgroups.

Can someone refresh my feeble mind on the code and where it goes.

Reply to this Message

Steve Schapel - 27 Oct 2007 19:50 GMT

G.,

I suppose the code would go on the Current event of the form. And I
suppose it would be something like this:
Me.YourCombobox = <whatever it is>

If you're doing what I think you're doing, for myself I would usually
prefer to leave a combobox whose purpose is to select specific records,
blank except when it is being used for that navigation purpose.

Signature

Steve Schapel, Microsoft Access MVP

> I swear as I get older, I get more forgetful. I've done this before, but its
> been about five years since I used the code.
[quoted text clipped - 5 lines]
>
> Can someone refresh my feeble mind on the code and where it goes.

Reply to this Message