I am trying to get my combo box to show all 3 fields in the dropdonwbut bound
to the 3rd field.  It keeps showing the 1st field after the selection how do
I get it to show the 3rd field?
I have colum count set to 3 and bound set to 3

Hey I have a quick question.  I have a form where the user can enter th
company's name, and then all the specs on one of their products.  The
then press enter and the whole thing is put into a table.  
Here is the problem.  I want some of the fields to stay the same.  Fo

Good afternoon,
***************************************
Goal:
I am trying to set up a form that searches Customer orders by name and

My database has a form called A/P where a vendor invoice is verified for
pricing against what the purchase order states.  The form pulls information
from the PO table.
When a price on the invoice is higher than the PO price, we change the price

I am sorry if this is not the right place to post this . But I coul
not think of a better place to get good info.
Can someone please suggest some very good books on Ms Access 2000 an
VBA. I am new to both and would like to learn.

I need the following code to work on the afterupdate event of a textbox on
my main form, but it doesn't.
Private Sub Command92_Click()
Me.IDRb_subform.SetFocus

I hope I can explain this correctly.
I have a database with 5 tables.  All five tables have the same three fields
that make up the primary key.  I want the three fields, when combined, to be
a Case Number.

I have a form created in FrontPage which dumps information into an Access
Database. One field "WorkshopDate" is a list box with 4 option dates. I need
to limit the number of 'signups' per date to 28. Any suggestions I could get
on this would be appreciated.

I have an Access 2000 database set up to open the main menu form at start up.
When I try to open the database it hangs up, the task manager tells me that
Access is not responding and I have to shut it down. If I bypass opening the
form at start up by holding down shift, the ...

Hi - I have an orders main form with an order details subform.  On the order
details subform, I've created a text box in the form footer to calculate the
subtotal of each order by multiplying the quantity by the item price.  On the
main form, I created a field that refers to this ...

I have a form that allows users to enter values into a table, which is then
the record source for a combo box elsewhere in the database.  For
import/export purposes, I'd like to prevent users from entering anything with
an apostrophe, as that screws up the process.  I just want ...

I'm building a form that will have 2 combo boxes for the user to utilize as
choices.  Once these choices are chosen, I want them to be able to click on a
command button that will take them to the next appropriate form.
Scenario:  User will pick "plan name" once chosen the next ...

Thank you for your help in advance
Well, I'm new to Access so any explanation may have to be worded in simple
language, but anyway...
Okay, I've created several forms which all have the field "patientid." Now

I have a form that counts the number of deliveries each day. How can I reset
the field to number one each day?
thank you
Michael

Also, I currently have my tables setup so that every order has an Order ID.
What should I do to create a form that enables a user to enter an Order ID to
bring up that record and make changes? Thanks.