I have the following code that I'm trying to use to 'view' one record of a
SQL table that I've linked to with Access 2002.  This code is behind a
button on a form.  On the form I enter a value in a control named custno.
When I click the button I get an error that says 'Too few ...

I have a data entry form where country(ies) (there can be more than one for
each project) is/are entered in a sub-form on a tab control. Countries not
listed are entered by the following:
Private Sub CountryName_NotInList(NewData As String, Response As Integer)

I'm using a VB Command to change the SQL statement on my Query
qry_SEARCH
On the main form, frm_SEARCH,  I have a sub form sfrm_SEARCH bound to
this Query

I have a form where users can enter three variables using three combo boxes
and the resulting records are shown in list box on the form. It works fine.
However, i would like
to be able to choose  "All" in one, two or all three combos. It is not a

Hello again all,
I am putting the finishing touches on my first project.  All thanks to
eveyone here.  I appreciate it.
Access 2000 database.

Hi.  I have reports that allow for user input (such as a date) and then run
the report using the preview command.  If the user begins to run the report,
but then decides not to run it and closes the parameter window, I get an
error message:

I'm using a VB Command to change the SQL statement on my Query
qry_SEARCH
On the main form, frm_SEARCH,  I have a sub form sfrm_SEARCH bound to
this Query

I'm using Access 03.  There are several instances on my forms where when I
add data I want another field to reflect the fact that addition information
has been added.  I've noticed that I can press F9 and the data in the fields
update.

I have a EmpID dropdown field with a query that selects all the Employees ID,
depending on the selection of the EmpID , I want to fill the next field with
the Employee's name that matches the EmpID matching the previous selection.
Thank you.

I have the following code in a form I'm using.   When I click on the button
to run this it brings up the input box twice.  Once as I would expect it and
the next time it shows the information typed into the input box as the
prompt data.   Any ideas on what I need to correct?

Private Sub SelectRecord_Click()
On Error GoTo Err_SelectRecord_Click
   Dim stDocName As String
   stDocName = "tblFlightNumberQuery"

I have a continuous form that is set to allow Edits, Deletions and Adds.  The
following statement in the On Current event procedure:
           If Forms![EDIT-Phys Offices].NewRecord = True Then
              [Confirm Add Record]

In many vb routine one can refere to things with [forms]![formname]....etc.
In vb routine i want to store the formname i am in in a variable.
So i would like to use [forms]!avariablecontainingmyformname...
Can anyone tell me how to get 'your own' formname you are in?

I am new to writing code, but need a code to call up quarterly reports
seperately. (From Jan to Mar, Apr to June, July to Sept and Oct to Dec. I can
call up for all the quarters now, but can't call up from different ones that
I could select along with the year too. Can anyone help ...

I am reposting this because I'm afraid it's too old to be found and
answered.
I have the following code that I'm trying to use to 'view' one record of a
SQL table that I've linked to with Access 2002.  This code is behind a