A little assistance.  Getting an error end if without block if.  This is
based on the selection of the account number assigned to a particular set of
3 states.  So if the combo box selection for AcctNum is 20, then I want the
combo box of the state Name to equal that number assigned ...

I have 2 queries; 1 selected query and the other one for Append query. When I
click the button, I'd like to do Selected query first to give a chance for
user to check and print the result. After that,  the system will run the
Append Query.

in access 2007 I am trying to user oncurrent event to set some free fields on
form
but behavior is very strange - filelds do not display current state
they display state like it was on a previous record

I am able to open a form using the syntax;
DoCmd.OpenForm "frmFormName", acNormal
The main form frmFormName has a subform in it frmsubSubformName.  Some code
in this subform refers to a value in a text field in the main form e.g.

i need to use a variable in the following expression that refers to a
subform. I want to replace city (this is field) with as string variable that
is the name of the field. Can anyone rewrite this expression to allow me to
use a string variable strFieldName in place of City

Access 2003, Windows XP
I am trying to actively stop duplicates from being entered on a form but
cannot seem to get the code to work correctly (or I'm going about it all
wrong).

Hi Everyone,
How do I write a code that will allow me to pick the latest revision. For
example, I have a document number 001-002 A, 001-002 B, and 001-002 AB. I
want it to return to me 001-002 AB as the latest one (i.e. not 001-002 B).

In an animal management database, I have a form where a combo box offers
selections of all the species in the species table.  The combo box displays
the species name (my 2nd column), but the value of the combo box is bound to
the species ID (the 1st column, 0" width).

I have some code on a form.  it calculates various costs to array variables,
then writes these variables to a load of labels on the form.  It was working
fine, but I need to run the same code from other forms so have been putting
it all into functions within a new module.

Hi I am using the following:
  If Len(Me.Comments4) > 0 Then
       DoCmd.RunCommand acCmdSpelling
           Else

Hey all,
I have a form named frmNewRepair which has a subform named fsubRepairDetail
and a "close" button named cmdFinish.
This subform (fsubRepairDetail) has several controls and another subform

I am set command button  on mouse move event to open some form with on timer
event. But if mouse pointer standing on command button without moving, on
mouse move event is repeating. How to set event to repeat only once when
mouse pointer move trought command button?

I have 2 listboxes on my forms, list1 and list2. When both are
selected and my command button is pressed, a query is run- based on
the two selections. How can I make it so that when I click my command
button, it checks to see that selections were made in list1 and list2-

I have a Mainform where the user selection from one or a multiple of 4
comboboxes and select a date range.  This information displays in a subform.
I would like to use a Command Button on the Mainform to export the
information displayed in the subform to Excel.  Suggestions Please ...

I need to show in ControlTip Text filtered result from three table fields.
How to do that?
Help!!!