Combobox filter and form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form displaying publication titles for different subjects, like

group Subject
Title
Law Informationtechnology The new Internet
Law Informationtechnology Internet Protocoll V6
Law Economy Social Politic today
Law Economy Welfare Stat after
1945
Law Law Copyright and
Internet
Law Law Responsibility
for Internet Links
Law next .... next....

I'm displaying data for a group and want to add new title for a group -
like "Law" or "business administration". Each title belongs to one subject,
there are around 20 subjects and there are 20 subjects. Each title can be
used in different groups, a law title maybe used in goup "Law" or in group
"Informationtechnology". In my form I'm adding titles to one group. All
titles for all subjects a displayed in a combo box. the user is selecting one
title an the title is added.
I need a filter for the combobox to display only the titles for one subject
- for example law.

If I use the filter, it is working fine for the new record, the titles are
displayed properly. But for the old records the titles are disappearing from
the combobox.
If I use a filter for "Law" in the last row to insert a law title, the
titles for economy are disappearing from display.

Any helpful hint??
 
If I understand you correctly then you are applying a filter to the RowSource
property of the combo box by altering its SQL. Can you post an explanation
of how youe are setting the RowSource (the code used) and can you also say
whether or not the "Limit To List" property is set to yes or no for the combo
box?
 
Hi Keith,

thanks for you quick answer.

The row source is like this: "SELECT ID, title, subject FROM mytable WHERE
subject LIKE my_subject_selection_field".
Default value for my_subject_selection_field is "*".

ID is primary key and only the key is saved, not the actual title.
Therefore I can't change the property "limit to list".
 
Back
Top