John:
Okay, I think I understand some of what you are saying. I opened the form
in design view. I looked at the properties. THe source is a table called
Client Information. Now, let me try to explain it to you this way. I have a
combo box that I have named as Billing #1. I also have a text box named Item
#1. The text box when you right click on it and click on properties, the
"control source" is based on another field. I need the Billing#1 combo box
to fill with a dollar amount based on the zip code that is entered into the
Item#1 text box. I am not sure if it would be easier for me to email you the
database so you can see it to understand what I am talking about. If you
would like me to, I can. Also, I was wondering if I had a combo box with a
list of items in it. If I wanted to select more then one of the items and
get them to list in subsequently a different box, how would i do that? For
instance, if the list box had A, B, C, and D as the list, and I wanted to
pick A, B and C. And each time i clicked on one I wanted it to pop up in
another box so they were all listed in the same area, how would i do that? I
am not sure if this makes any sense, but please let me know. I truly do
appreciate all of your help.
I'm sorry, but I'm a self-employed consultant. I work on other
peoples' databases, but I do so on contract for a fee. I volunteer my
time here in the newsgroup as a public service, but I do need to keep
it within limits!
I would STRONGLY suggest that you stop, step back a bit, and study up
a bit about how database design should work. You're talking about
"storing A, B, and C in a different box" - that makes *zero* sense in
a relational database; if you have such a one to many relationship,
you store the information in *two tables* in a one to many
relationship. YOu're also talking about "the Billing#1 combo box to
fill with a dollar amount" - as if a Combo Box contained data. It
doesn't; a combo box *is a display tool* to allow you to display and
select data which is stored in a Table.
I suspect that you started designing your database with this Form.
That's the wrong place to start! What you need to do instead is turn
off the computer, go into a different room, and get a pad of paper and
a #2 pencil with a good eraser. Identify the "Entities" - real-life
things, events, or people - of importance to your application. Do you
have Customers? A customer is a person, so you have a Person-type
Entity. You have Products? There's another entity. Sales? That's an
event-type entity in which (presumably) a Customer purchases several
Products.
Take a look a the Northwind sample database which came with Access (it
should be on your OfficePro or Access CD if it's not installed in the
Samples folder already). Take a look at
www.mvps.org/access and the
links therein; and at
http://support.microsoft.com, search for Access
database design. Or get one of the many good books on Access
databases.
Access is quite capable of doing what you want - but it's a lot more
work than setting up a spreadsheet or a Word document! And if you get
your table design off on the wrong foot, you'll have reams of
problems.
If you'ld like to post a real-life description of what you're trying
to accomplish, I or the other volunteers here can surely guide you in
the right direction; but I really hesitate to try to fix up this form,
because I fear it's built on a shaky foundation!
John W. Vinson[MVP]
