Default Value from another field ??

  • Thread starter Thread starter Stacy
  • Start date Start date
S

Stacy

I have a combo box that I want to populate with buyernames from preivious
(if there are prievious) names in that field for that company.
In other words if I have sold to Exxon and the buyers names that I
previously sold to were Bill John and Janet. I want the combo box to display
all those names and from that list I can choose one of those buyers or add a
new one.

I have another field which is a cumpany number (called billto) that I can
use to sort the 100's of other companies I do business with.
In an SQL querie is looks like this. (Although I think it is suppose to go
into Row Source)

SELECT orders.billto, orders.buyername
FROM orders
WHERE (((orders.billto)<>False And (orders.billto)=1000));

The problem is that this is hard coded to "=1000"
I want the some way to take the ="1000" and some sort of varable or
something that automatically selects the current cusomers list of buyers. In
other words


SELECT orders.billto, orders.buyername
FROM orders
WHERE (((orders.billto)<>False And (orders.billto)=(ORDERS.BILLTO)));

NOT CAPITALIZED "ORDERS.BILLTO" but this does not work.

Does anyone understand what Im saying and possibly have a solution??
I am running windows 2000 and Office 2000.

Regards
Steve
7willie
 
I have a combo box that I want to populate with buyernames from preivious
(if there are prievious) names in that field for that company.
In other words if I have sold to Exxon and the buyers names that I
previously sold to were Bill John and Janet. I want the combo box to display
all those names and from that list I can choose one of those buyers or add a
new one.
Click to expand...

See the sample code in http://www.mvps.org/access/forms/frm0028.htm.
Essentially you want to update the Buyer combo's RowSource query in
the afterupdate event of the Company combo.
 
Back
Top