How do I set the value of a list box control on a form base on the value from
a combo box on the same form?
Thanks

This came from a previous post.  See below:
I use Outlook to manage the appointments but I create them in Access. I
wrote an article in Access Advisor magazine last year explaing how to do it.
The sample database for that article is at:

Hi!  I'm trying to format a zip code so that it appears in the report as
12345-6789 if there are 9 digits in the underlying table of as 12345 if the
table only contains the 5 digit zip code.  Right now I'm using  the following
code which is omitting the dash:[City] & ", " & ...

I need help in setting up a strong foundation for my database.  I can pay
consulting fees if it becomes to cumbersome to discuss in these threads.  I'm
comfortable setting up many to many relationships through junction tables,
but the business I am trying to model here is more ...

Still having a fundamental problem making my database work. (I
received alot of help in earlier posts, and this is the last thing to
make this thing workable.)
Basically, I have 40 employees, some military, some civilian. As well

In Access I have several fields which occasionally are updated.  Fields of
interest are Qty Authorized, Quantity on hand which are updated during
inventory, how do I have a table automatically update Quantity short  
(Authorized minus on hand)

I'm running WinXp and Access 2003.
I've got a simple combo box that's roll source is a table. The problem
started when I added a new name to the table. Her name is 19 characters in
length. When I select her name from the combo box I get the "The field is too

i have a very specific need to have only 3 records in my "block serial"
table to be related to one record in my "product serial" table.
the company i work for makes a product where the compressor products that we
manufacture have upto 3 blocks in them. there is information that we ...

Is this possible? Here's the scenario, the tracking system is meant to
track time spent on client/project/activity with each of those being
heirarchal. That is to say I have 4 tables that are linked similar to
this

Does anyone have a template for an Access mailing list application? This is
not going to be a mail-merge application and MS Word is not involved. All
data will be kept in Access and it will print mailing labels only.

In a long-term fit of normalization, I designed my application to have one
master lookup table with a "type" column (where the lookup values were
commonly similar--code, desc, long desc, etc.).
I have 33 different types of lookup fields with (currently) ~1,400 rows.  

I have a database with 12 tables.  I want to do a simple query where I would
get the count of three different tables.
Count(TableA)
Count(TableB)

I am interested in informed feedback on the use of Constraints, Primary Keys
and Unique.
The following SQL statement creates a Bands tables for a database of
bookings Bands into Venues, where the rule of the business is that only band

I would like to know how to update severval fields in table at one time with
a  query module...
Thks

I am new to Access and I am trying (unsuccessfully so far) to design a
database for our wafer lots. I have entered all of the information into a
spreadsheet in both Record and Field format. I have tried using the Data
Wizard but am unable to get what I need in terms of Primary Key. ...