Update Field on Form based on value selected in a different field

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

Guest

There are certain products in certain categories. When the user selects a
category on an order form I am trying to allow the combo box for product id
to show only the products that are associated with the category selelcted. I
have tried the AfterUpdate event but cannot get the product id to filter the
list to the category selected.
 
This is asked and answered all the time. Try searching for "Cascading combo
boxes" in the Help file, forums, or Microsoft's Knowledge Base.
 
Sounds like cascading combo boxes. The list in one depends on the value in
another.

If so, search for "cascading" and read the hundreds of previous posts that
explain how to do this.

Rick b
 
Thanks I did find the cascading information.

The problem I am having is the product id combo box which shows both the id
and name populates the product name field using the AfterUpdate event using
Me!ProductName = Me![ProductID].Column(1). If the product name field is
changed to an unbound combo box the id no longer populates the product name.
I need both of these fields to populate the order detail table which drives a
report.

It's almost as if I can have one or the other functions but not both.
 
Back
Top