Hello group mates:
I've searched the groups but have only come up with half the answer.
Please forgive the stupid question.
I have a form with 2 pages in a tab control.

i need a code where I can filter the records by date.
what is the vbc query.
the filed on my Issue table is "opened Date"
Thanks for your help

I'm hoping someone can help.  I'm trying to execute a filter on a form that
utilizes a subform.  I also have a combo box on the form, which when the
filter is applied, works.  I just can't get the subform part to work.  I
receive the error: "Is not a valid name.  Make sure it ...

I have a form I have created (data source is a query) that is being used to
create a "checklist" form.  So, I have these items in each row:
Item                 Risk Factor         Complete          Status
--------------      ------------          -----------         --------

I have a form with an unbound text box txtDept.  I Have code attached to the
afte update event of this tevt box only.  I have a button with code
DoCmd.Close "fromName",acSaveNo.  When I press the button a parmeter box is
displayed requested the value of txtDept.  If I select ...

I want to filter by date on my form. I want to input the date range from to
TO: and search. what is the code I can use to write for filtring between
dates,

Tried to use IF and IF. It fails. Haven't found a solution. Suggestions?
'check for data in mandatory data fields
If Me.IntervalType = "Hours" Or Me.IntervalType = "Cycles" And
IsNull(Me.Interval) Or Me.Interval = "" Then

I am looking for a way to fill a combo box from two text box values on the
form.  The problem is the data is not stored in a table because the user is
in data entry mode.  Example, User will select the primary email from
[cmbPrimaryEmail] and the value list will come from ...

On my Data entry form, i have open date and Due date. How can I default due
date so, its alway = to open date. with out doing the entry.
so, i can due date.
Pl advsie. thanks

hey all,
I have some code that is intended to dupe a set of records in a table and
related table.
It works fine for the first table duping as many records as appear in the

I get error when I run this code to search inbetween the dates. Any advsie
pl.
' If Opened Date From
   'If IsDate(Me.OpenedDateFrom) Then

I am totally new to using a recordset clone, and perhaps this is not the
right application of it . . .
I have an application whose only form will contain a command button to start
the action.  What it needs to do is to take a table and record-by-record,

I have a form with two combo boxes, Style and BlendID.  For each new record,
if the user selects an existing Style, I want to display the corresponding
BlendID.  If a new Style is typed in, I want the user to be able to select an
existing BlendID or enter a new one.  Complicating ...

I admit first that I am not very good using SQL.  I am new to Access,
but I am trying to pass a selection in a list box as criteria for a
query.  This list box is set to Multiselect "None", so I only need to
pass a single selection to the query.  The list box is populated with

I'm having a bit of a problem with this Dlookup:
If DLookup("[Company Ref]", "Main", "[Company Ref] ='" & Forms!
[frmUpdateClaim]![Company Ref] & "' and [Registration Number] ='" & Forms!
[frmUpdateClaim]![Registration Number] & "' and [Settled] ='" & -1) Then