Subform problem

mig144

Registered User.
Local time
Today, 09:15
Joined
Nov 7, 2005
Messages
23
I have a subform which is a straightforward subform, an inventory of items, the main form of which is the location of this list of items.

I want the subform to show all but one sort of item, located in the "ProductType" field. That item is called "Delivery" and is linked to a lookup table, the fields of which are "ProductType" and "Price".

How do I make sure that "Delivery" is not shown on this subform? I have tried to base it on a query, but the items are not updateable that way. Is there another way?

I am planning to record delivery in a different form.

Thanks,

Mrs Miggins
 

Users who are viewing this thread

Back
Top Bottom