Combo box for Searching

[Guest]

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

 

[Duane Hookom]

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

 

[Jeff Boyce]

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>

 

[Guest]

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