Re: Drop-down box in record display

Tech-Archive recommends: Fix windows errors by optimizing your registry

=?Utf-8?B?Qm9iIEJyaWRnZXM=?= <rhbridg.RemoveThisNode@xxxxxxxxxxxxx>
wrote in news:320F9A69-E312-4D28-9FBF-CBD5BE8BA338@xxxxxxxxxxxxx:

Hey, is there a way to display certain values from a record in a
drop-down box, so that each detail section in the form has a
different set of values? I find it's easy enough to put the combo
box in the detail section, but after that every combo box - each
one in every record, I mean - always shows the same set of values.
Is it possible to get each one to list a different set of values
relevant to its own record, somehow?

Ignore my previous response I misread your question.

Yes there is a way, What you need to do is to filter the list of
values based on some field in the query.

Since you haven't provided much detail, I can't give much of an
answer, but the idea is to put a field in the table that is the row
source for the list section of the combobox, that identifies what
type of entry the main record is, you modify hte query that takes
that data into the combo box, to filter on that field, then
requeries the combobox whenever you change records.

--
Bob Quintal

PA is y I've altered my email address.
** Posted from http://www.teranews.com **
.

Relevant Pages

  • Re: Select or Filtering on a related group
    ... >> Binding. ... >> You could bind all three objects, the Securities ComboBox, the Exchanges ... > this to Filter the ExchSec DataView.. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: vba sort a query
    ... I have many comboboxes with different selections and I have this code ... that i have on a 'filter' button so when I click the filter the ... comboboxes but sort by what is selected in the sortby combobox. ... Dim strdoc As String ...
    (microsoft.public.access.formscoding)
  • Re: Select or Filtering on a related group
    ... > ComboBox and the ExchSec grid to three separate DataView objects, ... > clicks a row in the grid, you can grab the exchange value (which can not be ... this to Filter the ExchSec DataView.. ... > Think about the complexity of what you're talking about in terms of binding. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: datagrid combobox question
    ... combobox you will wind up changing values in rows that arent being edited. ... So what you need to do is just before the combobox is displayed you need to ... What I want to do is to filter the list of Locations in the combo box to ... > If you bind the data you will wind up changing the values in multiple ...
    (microsoft.public.dotnet.languages.vb)
  • Re: need help with filtering a list
    ... Put a combobox from the Control Toolbox on your sheet. ... When you select from the combobox, the filter is removed. ... entry creates and autofilter and sets the custom filter to 'contains' ... > location cells, there is more than one location. ...
    (microsoft.public.excel.programming)