I am trying to create combo box on a form that shows the correct auto
"Models" based on what is chosen in the combo box "Makes". First I made a
"Makes" table that has "MakeID" as the primary key, then I made a "Models"
table with four fields: ModelID, ModelName, MakeID, MakeName. ...

Hi, I'm a complete novice on Access, but with a lot of experience on
Excel.
How would I go about the above?

I am using a combo box to select records from my qry. It views 3 columns, and
it searches on last name. It shows last name, first name, and MI. I have
multiple last names, say Smith, and if I try to select the third Smith in the
list, it only brings up the first Smith in the list ...

I'm a competant database programmer but new to Access. We've got a (soon to
be) enterprise wide asphalt plant ticketing software that is all custom
coded in SqlWindows, but because of HMI interface, has to be on Access.
What's some of the best APPLICATION DEVELOPMENT books out ...

I have a table for workorders that has a drop down for the username in a
seperate table called customers, when you select the user, how can i pull the
phone number in a seperate field based off the drop down based off the name.

Hello Partner
Please forward some good resumes with excellent communication skills.
1.REMEDY AR CONSULTANT
Exp: 6-10YEAR

I created a form and I want to see all previous items in the form.  Exampel 1
of 31 records but when I select Data entry No the 1 of 31 appears for a brief
moment.  When I close the form and go back in to look at it again, the form
shows 1 of 1 again.  How do I fix this to stay ...

I have a form in which I want to be able to enter a string of any part of a
field into a combo box which will bring up all the instances in the table
with that string to select from.
Any suggestions in Access Monster Land.

I am using the inventory template in Access 2000, and the product ID field is
auto number and I want to use our product ID numbers.  How would I go about
doing this?

I have a need to collect data from input forms. My problem is that on
these forms much of the data is the same from form to form. How can I
set the form up so that it will remain from input to input until
overwritten? Example: I am inputing surveys on classes. I want the

I want to disable a couple of controls (text boxes) on a subform based on the
content of a combo box on the main form. It could work either in the
MyComboBox_AfterUpdate or SubForm_Enter. However, I cannot get it to work
from either of these, nor in the Activate or GotFocus of ...

I have an interesting problem. I have a continuous form, bound to a data
source, showing a number of records, one line per record, with a vertical
scroll bar. As far it is the "most normal thing" that Access can do. One
control of such a record is a push button, and when the user ...

I have an application made by someone else which has a switchboard form that
it directly opens to.  No commands are apparent from the menu bar which I can
use to open and edit as I need to.  
I know there is a keystroke that will allow me to bypass the switchboard.  I

I have a work order form that has a drop down for the user name, the concept
is as follows.
When you select the username, the computer name, IP Address, Phone Number
fields will fill. Can this be done? The fields required come from a Customer

I am currently in the process of developing a database that will keep track
of appointments that patients will have in the future. 2 tables; Demographics
and Visits. The visit table will hold future visits patients have. What I am
needing, I am wanting to populate multiple visit ...