Drop Down Boxes

Afternoon All

I'm kind of new to access forms. I've used them a bit to add records to a table or run a query with command buttons etc. but I've never done this:

What I want to do is, have a drop down box where you select the company branch from a table then when you click on the branch name it shows the amount of products that they have sold in a text box underneith. All the data I need ,
the branch name, the product, the weight is in one table.

I hope I am coming over cleary enough.

Any help would be appreciated.
Cheers in advance

Simon

You may want to use a calculated textbox and the DSum function. For the
criteria portion of the DSum function, you would refer to the value of the
combobox. This will limit the value to the company branch you've picked.

Example:
=DSum("[ProductSoldFieldName]", "[Table or Query Name]", "[CompanyBranch]='"
& cboMyCombo & "'")

--
Wayne Morgan
Microsoft Access MVP


"Simon" wrote in message
...
Afternoon All

I'm kind of new to access forms. I've used them a bit to add records to a
table or run a query with command buttons etc. but I've never done this:

What I want to do is, have a drop down box where you select the company
branch from a table then when you click on the branch name it shows the
amount of products that they have sold in a text box underneith. All the
data I need ,
the branch name, the product, the weight is in one table.

I hope I am coming over cleary enough.

Any help would be appreciated.
Cheers in advance

Simon