choose multiple items from a form in access

[Guest]

I have what I hope are two simple questions. I'm helping a non-profit try to
keep track of a fundraiser (selling geraniums). I have an order entry form
that starts by using a combo box to pick a customer. I want the combo box to
be bound by the customer ID, but I'd like it to display either the company
name, or if there is no company, the individuals name. I tried using the
following equation
(name=iif(isnull(companyname),iff(isnull(firstname2),lastname&", "&firstname,
lastname&", "&firstname&" and "&firstname2), companyname) in the rowsource.
when I run the query it shows the correct ID/calculated name, however when I
go to choose the value from the combo box it lists blanks if there is no
company name. Any ideas would be greatly appreciated.

Second, once the customer is chosen, I need to be able to add the number of
different type of flowers that he is purchasing. I've got a "products" table
that lists all choices along (e.g. 4 in red, 4 in white, 4 in magenta, 1 gal
red, ...) with their cost, and a "orders" table that includes the quantities
for the products that are being purchased. Ideally I'd like to have the form
show all of the types available, with a blank next to each type where the
user can type in the number that a customer is ordering. this seems like it
should be fairly straightforward, but I'm having a difficult time figuring it
out.

If anyone can point me to an example or let me know what I need to do I
would really appreciate it. Thanks.

 

[Arvin Meyer [MVP]]

In your query try adding a column like:

CustomerName: IIf(IsNull([CompanyName], [LastName] & (", " + [FirstName]),
[CompanyName]))

Then use:

Select CustomerID, CustomerName From MyQuery;

As the row source of your combo box.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access