on my main form, I have a subform which is not linked to the main form. The
record source points to a normal Access table, property orderbyon = true with
orderby statement containing one field as order criteria. I'm using Access
2000.

I have a form with multiple subforms.  Simply described, here is the layout
MAINFORM = main form, unlinked
SubformA = Linked to MAINFORM by unique RecordID
SubformB = Linked to SubformA by SubRecordID

   Is it possible to have a form fill in two fields by clicking on a drop
down list of just one of the fields.
...for example.
two fields, A and B, where field A has a drop down list with two columns

I have two tables that are related numerically by the month.  1 for Jan., 2
for Feb, 3 for March etc.  On one form connected to table 1, I can easily
select the month through a combo box, the data is entered monthly to
determine the office cost for a specific month.  On the ...

Hi,
I am trying to improve the functionality of my form by providing a filtered
combo boxes.
I have 2 tables

I am trying to create synchronized combo boxes and store the text in a
seperate table.  Much like
http://support.microsoft.com/default.aspx?scid=kb;en-us;209576
The only problem is when I try to store the values in my table, all I get

I have an updated query attached to the "on close" event of a form in Access.
But now, before Access allows me to close the form, I get a warning that the
query is about to run and that "x" number of records will be changed.
How do I turn off this irritating warning/

I've created a form containing a subform. When the form was first created,
the subform allowed new records. I don't think that I have changed the form
since I added the first records but now the subform will not add records. The
AllowAdditions property of both the form and ...

I have a database with Classes, Students, Enrollments, etc. tables.  I have
form where I want to "assign" each student to a class.  The form is based on
the Students table, and I have a subform based on my Enrollements and
Sessions tables.

Can't find the answer to this, I have created a form with a list box which
allows multiple selections. I want to then open another form which shows info
on all records chosen from the list box. Tried setting the 2nd form criteria
to list box control but did not really think that ...

I've got a form with a calculated text field that displays the text
"#Name?" when I show the form.  
What's really confusing is that the expression is defined.  For
example if I put in "TotalList", where TotalList is a field in the

I created a database for work done in 2004.  Along with the database I
designed a form in which to enter the data I wanted to enter into the
database/tables.  Now I want to created a new database for 2005, but I want
to use the form I designed for 2004 as the form for the 2005 ...

I ask, as I can set up a sub-form on a form, but only want the sub-form to be
opened, when 2 combo-boxes have been selected.  I can do this, and then open
a form - but cannot open it as a sub-form
Many thanks in advance

This is my first ever database design with little or no access training.
Please excuse me if this is a stupid question.
I have multiple tables set up for different types of information on my
database.

I want to create a form to enter data into a table.
here is how I would like it to work.
The user would select one value in list for field #1, then in field #2 a
list would appear that would be dependent on the value selected in field #1.