Form Filter off of a combo box, only on existing entries

[Tboartz]

I have a form that on load opens to a new record. I need to apply a filter
that based up on a combo box will only reflect particular records when
reviewing existing records. It must accept an entry of either a specific term
or the field can be null. I cannot seem to get the filters to work properly,
I've tried several schemes including basing the combo box off a query to show
only specific responses (specific term or a null field). Any help would be
appreciated. Thank you.

 

[John W. Vinson]

I have a form that on load opens to a new record. I need to apply a filter
that based up on a combo box will only reflect particular records when
reviewing existing records. It must accept an entry of either a specific term
or the field can be null. I cannot seem to get the filters to work properly,
I've tried several schemes including basing the combo box off a query to show
only specific responses (specific term or a null field). Any help would be
appreciated. Thank you.

It's hard to give a specific answer since you don't post any information about
the structure of your tables, the exact nature of the problem ("specific
term"...?) or the details of what you've tried.

A Combo box based on a query would seem to be indicated. I don't see where a
filter comes in, since that would limit which *EXISTING* records would be
displayed; adding a new record isn't affected by filters, so I'm not sure what
you're getting at.

Could you post a more specific example of what you want?

 

[Tboartz]

I have a group of tables coming together that ultimately 4 main forms pull
from (every form has something from each of these tables). These forms are
exact with the only distinction being an individual product. So for example,
the first form is everything applicable to the product line for steel pipes.
The second form is asks for the same information but is in respect to another
product line aluminum pipes, then there are two other main forms for two
other product lines. I have them attached to one main table because the data
will be looked at together as well as individually and this is the best that
i could develop rationally at the time.

On each form there is a combo box, with specific terms to reflect each
product line (so SP for steel pipes, and AP for aluminum pipes, etc). I need
to make sure that the form for the individual product line, steel pipes, only
shows either a brand new record for entry or existing entries for the SP
code. Maybe i am looking at this the wrong way, wouldn't be the first time. I
hope this makes more sense to you at least what i have done. The filters i
have applied are failing to reflect only one code per form. If i open a form,
scroll back through the records, it will pull up both SP as well as AP.

Thank you for trying to help me

 

[John W. Vinson]

I have a group of tables coming together that ultimately 4 main forms pull
from (every form has something from each of these tables).

Is this a form/subform arrangement? or are you trying to base the form on a
query joining all the tables? or are there combo boxes or listboxes displaying
some of the other tables' data?

These forms are
exact with the only distinction being an individual product. So for example,
the first form is everything applicable to the product line for steel pipes.

Unless the Form has *structural* differences, it would be rather unusual to
use different but basically identical forms just because they are displaying
different data. How do these forms differ (in structure, as opposed to the
data you're displaying)?

The second form is asks for the same information but is in respect to another
product line aluminum pipes, then there are two other main forms for two
other product lines. I have them attached to one main table because the data
will be looked at together as well as individually and this is the best that
i could develop rationally at the time.

Normally you would have one Form and use a query to select (e.g.) just
aluminium pipe data for the form.

On each form there is a combo box, with specific terms to reflect each
product line (so SP for steel pipes, and AP for aluminum pipes, etc).

Sounds like you need to base the combo on a query referencing... *SOMETHING*,
I can't tell what here... specifying the type of pipe currently on the form.

I need
to make sure that the form for the individual product line, steel pipes, only
shows either a brand new record for entry or existing entries for the SP
code.

Then base the form on a query referencing the appropriate subset of the data.

Maybe i am looking at this the wrong way, wouldn't be the first time. I
hope this makes more sense to you at least what i have done. The filters i
have applied are failing to reflect only one code per form. If i open a form,
scroll back through the records, it will pull up both SP as well as AP.

What is the Recordsource Property of the form? How are you trying to apply the
filters now? Please post the code.