Combo box for Searching

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Aliennation2002 - 05 Sep 2005 19:22 GMT

Hi I want to open a combo box with list of all the software in the field
SoftWareWithVersion. then when it is selected it will call the contents of
the related record.
when I create a combo box all it does is change the field of the current
record and gives an error because it will create a duplicate record.
Regards John

Reply to this Message

Duane Hookom - 05 Sep 2005 19:35 GMT

There is a wizard for creating a combo box that does this. The combo box
should not have anything in its Control Source property.

Signature

Duane Hookom
MS Access MVP

> Hi I want to open a combo box with list of all the software in the field
> SoftWareWithVersion. then when it is selected it will call the contents of
> the related record.
> when I create a combo box all it does is change the field of the current
> record and gives an error because it will create a duplicate record.
> Regards John

Reply to this Message

Aliennation2002 - 06 Sep 2005 00:00 GMT

I had trouble getting the wizard to run until I dropped the security settings.
Regards John

> There is a wizard for creating a combo box that does this. The combo box
> should not have anything in its Control Source property.
[quoted text clipped - 5 lines]
> > record and gives an error because it will create a duplicate record.
> > Regards John

Reply to this Message

Jeff Boyce - 05 Sep 2005 19:41 GMT

John

Any chance your combo box is bound to one of the fields? (I'm guessing it
is.)

If so, don't! Use an unbound combo box to look up possibles. Then, in the
combo box's AfterUpdate event, filter the form or requery it, using the
contents of the combo box as your criterion.

Good luck

Jeff Boyce
<Access MVP>

Reply to this Message