I need to develop a complex form and am having a couple difficulties.  I
normally use VFP, but this particular application requires Access, so I am
struggling a bit.
The application has do main challenges.  First, the data is stored in a

I have a form with a subform.  I can set a filter on the main form with no
problem.  I can also set a filter on the values of a subform.
However, when I try to remove the filter from the subform the filter at the
main form is removed instead.  The subform filter remains.  So far ...

I have an Order Entry database from the access templates.
I have a table Orders and a table Order Details.  Orders primary key is
Order ID.  Order Details is linked to this table using 1 to many -- Orders
to Order Details (OrderID in both tables).

I'm new to MS Access and I have been given this project to work on.  
 I have 2 tables and a form
Job Type: Job Name, Job Type ID (primary Key), Job Title and so forth..
JobEvent: Job Name,Job Event ID(Primary Key), JobType ID(Foreign Key), Job

I am trying to filter a subform using an input parameter and a function. The
main form (frmStudent) and the subform (frmSubStudentYears) are linked
together on a unique ID. The value of the filter is determined from a combo
box on a seperate form (frmSelectYear.ComboxYear).

I have a Main Switchboard form which points to a sub form.
Within that sub form, I'm placing combo boxes.  The first combo box will
have the user choose a plan name (tblPlan).  After that choice, the user will
then go to the next combo box & choose the related product to that plan ...

I have a database holding information about our employees including some date
fields. We have had problems with our recruitment administrator's profile in
that when she put in dates, the system changed the display of dates from UK
to US format, so instead of someone starting on ...

I have a form called Work Orders and on it is a subform called Work Order
Details.  On my main form there is an field named ItemCount.  I need to know
how to programtically put a count of all of the records on my Work Order
Detail Subform into this field.

How do I get a form to automatically fill in something that was entered
previously in this field, after someone starts typing the correct entry?
In other words, I want the Table (I guess) to look up itself.  Can this be
done?  I see it all the time in commercial programs, some of ...

Is there any product that will allow me to spell check Access memo fields
and possibly other fields? Is it possible to try the product before I buy it?
Any help in this matter is highly appreciated. Thanks.

I get error when opening a report from a list box, I have try making a
query def and it works, I also have work with the following sub for a
numeric field.
Case "frmContacInfo_Prod"

I have a list box in a form, where users can select one or more
(Multiselect) Machines from a list. I want to use the selected Machines as
Criteria in a query (Machine1 OR Machine2 OR Machine3 etcetera) and have it
shown as Pivot in the subform.

I have the following code:
   Dim rs As DAO.Recordset
   Dim TheLocID As Integer
   Set rs = Me.F_LocationsSubForm2.Form.Recordset

I am unable to import a .dbf file into access. I am using Transfer Database
action but it keeps giving errors. Seems that I am unable to interpret the
command properly. Can anybody please give me the syntax/command to import
the .dbf file???

Good morning,
Here is something I'm tryng to do, but can't seem to get a handle on.  I am
hoping for some direction.
I have the following things listed in a listbox:  today, this week, this