Re: Reducing the List items on a combo

You will need a way to indicate that a particular item has been chosen, and
requery the Combo (assuming you are using a Query for the Row Source) to
create a new list. You'll have to determine the scope of this "used, don't
use again" rule and code accordingly... your code will be different if the
scope is "this record", "this session", "this date", or "ever and always".

If you are choosing from a Value List, then it is totally under your
control, and you can provide code in the AfterUpdate event of the Combo to
replace the list after you eliminate the item that was chosen.

Larry Linson
Microsoft Office Access MVP


<henry.onovwaka@xxxxxxxxx> wrote in message
news:580e61e8-35e0-49a8-86fd-e33e99df863f@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Can someone help on this problem.

I have a combo box of, say three Items, selected from a table that
serves as the lookup: E.g. 1 Earth, 2 Pine, 3 Earth Grave
The combo box is on the subform.

If the user selects any of the item, that item so selected should not
appear in the list again; or
The user should be warned about previous selection.

I dont want the user accidentally selecting the same item out of
error.

Will be grateful if someone can give me a solution.


.

Relevant Pages

  • RE: Easy Drop Down Box Question
    ... your search criteria. ... For that you will need a query that will include the ... As it stands now, after I changed the row source code, when I open the "PSV" ... Case Else 'Multiple Selection ...
    (microsoft.public.access.forms)
  • 2 Combo Box Menu from Multiple Query
    ... Once the phase has been selected a second combo box would populate. ... I can not requery combo box 2 based on the selection of combo box 1 ... becuase of the complexity of the query to sort each phase. ... Is there a way to set the row source of combo box 2 to a specific query ...
    (comp.databases.ms-access)
  • RE: Using field list as criteria to select records
    ... The way to filter a field list type row source type is rather than to use the ... want to select from and use the query name as the row source. ... The other field names are ACMM, ASM, CD-ROM, etc. ... field list for selection. ...
    (microsoft.public.access.queries)
  • RE: Designing Query - Help Please ASAP
    ... Paste the above SQL into a new blank query in SQL view and save it while ... "tmdrake" wrote: ... "Ken Sheridan" wrote: ... If I make a selection in the ProjectID box = then the subform will ...
    (microsoft.public.access.queries)
  • RE: Code using list box and multi select option
    ... OK I understand you make a selection in your query that refers to a field on ... once in using the filter in the code. ... Dim strFltr As String ...
    (microsoft.public.access.formscoding)