Why not provide a Search Text box then, as you neither wish to limit to
existing entries nor allow new entry unconditionally.
The entry in the text box can be matched to the WS list (VLOOKUP/MATCH etc)
or the combobox.list items, during the TextBox_Change event.
NickHK
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> I could, but that would not work with the process,
>
> What I want is if the entry is not in the list for it to warn the data
> entry person that they have to add this item into the other sheet, but
> i still want them to be able to finish there current entry before going
> to add the item,
>
> eventually i want if the item is not in the list then the entry will
> continue , and when it is entered with the ok button then it open up
> the "FormAdAsset" and put the new serial number into the "TextSerialNo"
> field so that the asset can be added
>
> so really the msgbox warning is just a interm until i have the time to
> write the code for what i really want it to do, which will just be an
> extension to the warning code im after
>
> make sense?
>
> cheers
> On Jan 24, 10:50 am, "NickHK" <TungChe...@Invalid.com> wrote:
> > Can you not just set the combobox.Style to fmStyleDropDownList ?
> > Then the entry must be in the list.
> >
> > NickHK
> >
> > <colli...@hotmail.com> wrote in
messagenews:(E-Mail Removed)...
> >
> >
> >
> > > Ok I have had a look arround, and nothing seems to be what i need, and
> > > what seems like i need doesnt make sense.
> >
> > > What I require is code so that if an entry that is put into a combo
box
> > > is not in the "rowsource" list then I would like a message box to
> > > appear to warn the data entry person,
> >
> > > my rowsource is a range called "SerialMaster" and my combobox is
called
> > > "ComboSerialNo"
> >
> > > Any help would be greatly apprechiated- Hide quoted text -- Show
quoted text -
>
|
Similar Threads
