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

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.
 
M

Mark

This is asked and answered all the time. Try searching for "Cascading combo
boxes" in the Help file, forums, or Microsoft's Knowledge Base.
 
R

Rick B

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top