Drop Down List - So easy it scares me that I need help

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

Guest

All,

I have a drop down list that I use to show me a list of our porducts, it
work great but here is my challenge. in the continuous form that I am using
the Chef enters what items he has used in the past 30 days, I capture the
Date and time used. but he does not want to use it again for the next 30
days. my drop down list keeps showing all of the items.

I have two tables;

tblDateEntry: has Product & date used and customer numbers
tblProduct: a list of all of the products. ProdID and ProdDesc.

Can anyone Help me with this?
 
Change the Row Source property of your combo box to include tlDateEntry.
Link the products (show all products and only corresponding date entries) and
add the date used field with the criteria <Date()-30 or Is Null.
 
Thanks, But i have a twist to this also. there are multiple customers that
are used.

Example: Customer A on 10/1/2006 uses Product 123, I dont want to see it on
the list for 30 days for that Customer only,

Customer B still can use the product and should show on the list.

Any Ideas.

Tables:
tblProduct;
ProdID
ProdDesc
tblDateEntry;
Date
ProdID
ChefID
 
You have to create a query that shows the results you want. To do so, the
Customer in question must be identified for the query. Then you'd use some
criteria like:

(Customer = CurrentCustomer) AND (Date<Date()-30 or Is Null)

Thanks, But i have a twist to this also. there are multiple customers that
are used.

Example: Customer A on 10/1/2006 uses Product 123, I dont want to see it on
the list for 30 days for that Customer only,

Customer B still can use the product and should show on the list.

Any Ideas.

Tables:
tblProduct;
ProdID
ProdDesc
tblDateEntry;
Date
ProdID
ChefID

Change the Row Source property of your combo box to include tlDateEntry.
Link the products (show all products and only corresponding date entries) and
Click to expand...
[quoted text clipped - 14 lines]
Click to expand...
 
Back
Top