My Subform

T

TyF

I enter a date I request pick up of a product. When the product is picked up,
I entered that date. In my subform, I only want to see the products without a
pick up date. What do I do?
 
J

John W. Vinson

I enter a date I request pick up of a product. When the product is picked up,
I entered that date. In my subform, I only want to see the products without a
pick up date. What do I do?

Base the Subform on a query with a criterion of

IS NULL

on the PickupDate field.
 
T

TyF

Okay one more question, I can't remember....Do you create a new subform based
on my newly created query. My original subform is embedded inside my
location form. I have at least 9 location to track. My goal is to be able
to go into that form and only see the products that is not picked up not the
ones that have been.
 
J

John W. Vinson

Okay one more question, I can't remember....Do you create a new subform based
on my newly created query. My original subform is embedded inside my
location form. I have at least 9 location to track. My goal is to be able
to go into that form and only see the products that is not picked up not the
ones that have been.

Simplest would probably be to just change the Recordsource property of the
form you're using as a subform to the Query (rather than the table).
 
T

TyF

Thanks that worked.

John W. Vinson said:
Simplest would probably be to just change the Recordsource property of the
form you're using as a subform to the Query (rather than the table).
 
Top