Good Morning,
I have a form based on a query.  I am using two fields from the query.  I
have inserted a second form as a subfom.  It is based on a table.  The
subform works fine when I open it by itself, but that will not help me

I have a form that is used by multiple users editing fields to assign
that resource to a customer. Can anyone tell me a way of making the
record field exclusive once it has been clicked to stop double
assigning please

Hi there - may seem like a really simple thing but for some reason I can't
get this to work,
I have a form in which I want to create a new record,
I then have a subform within the form in which I want to create a new record

My form which is based on a query called INVOICE,  has two comdo boxes apart
from other fields. The first combo box named  TOID when on click gets down
(lookup) data from a table call PEOPLE, which has a  list of people  and
another combo box named CONID, which is related, gets ...

So I have 3 combo boxes each having two columns, within a form. Next to each
combo box is a text box that shows the price based on the selected product
from the combo box. How do I sum all 3 TEXT box values in another text box
called Total?

I am looking for a way of setting up help / instructions for the use of forms
in my database. I have used help tips for buttons and fields but I would like
to set up detailed instructions for the use of each form.
I have thought about setting up a help table, query and form, so ...

I am going to need to make a form with 4 tabs (from 4 tables).  I
understand how to make the tabs, and I can get one tab to pull from one
table's field list, fine. But how can I make the form pull from more
than one table?  Is that going to require a query that collects all the

I'm trying to perform a standard filter on a text field bound to a form.  
When I do a find (Ctrl-F) I have no problems.  However, if I try to do a
filter (Right-Click, filter fill in), I get the message:
   "Type mismatch in expression"

I have a form with 2 subforms
How do I change the focus from a field on subforma to filed on subform b?
I want this on on the after update event.
Thanks

I have started getting the error 'The openReport Action was cancelled' when I
try to run a report, any report, from any database that I have.  When I go
the the database window and try to run it from there, it does nothing, and
now I cannot even generate a new report.  When I try ...

I have a combo box that has 2 columns and it will save the 1st value into my
control source but how do I get it to save the 2nd value to a different
control source at the same time?
EX:    

I am working with Access 2003.  I have 3 tables that I've linked.  I now want
to create a form to present different fields from the 3 tables.  I want some
of the fields to be input fields with a drop down menu.
My problem is that it does not appear that Access will let me input ...

Access 2000.  I have an unbound form with, a textbox to enter the file name,
and two texboxes to enter the beginning and ending date.  I also have a cmd
button which runs a macro to transfer spreadsheet to the "F" drive.   This
is fine if the drive is always "F", sometimes it may ...

I am using combobox1 to filter values in combobox2 by way of a dynamic SQL
statement (modifying WHERE clause).
Combobox1 is populated by a query on formLocations and contains Location1,
Location2...

I am building a land parcel database that will have 4 or 5 tabbed forms.
One of the tabs will be the "Parcel Info" record, which in most cases is
two people (husband and wife).  But sometimes there are as many as 4
co-owners. I have already built the fields to accommodate up to 4