I have a listbox that has the following SQL in a query:
SELECT tblResponsesList.Rspns, tblResponsesList.QstnID
FROM tblResponsesList
WHERE (((tblResponsesList.QstnID)=[Form]![QstnID]));

In my form, I want the values of all fields to be filled in by values from
the previos record. I understand from another post that one way is to have
the following code written into 'After Update' property of a field, say
Campaign Name :

What I'm trying to do seems simple, but I can't get it to work.  I've got a
form that builds a SQL statement for a pass-through query as the user selects
criteria on the form.  One of the criteria is a date range.  I want the "end
date" to default to the last_update_date in the ...

For some reason that I cannot explain when I type the straight numeric value
617 in the A Cell of my spreadsheet, Excel converts it to 9/7/1901 or 9-Sep.
In Tools Menu, Options, Edit I have cleared the check box for Automatic
completion.

I have an unbound Combo Box (cboDestination) on the header of my form
(txtForm).
The combo selects destinations from a Child table (tblDestinations):
SELECT tblDestinations.DestinationsID, tblDestinations.Destination,

I have a form with alot of textboxes. Each of these textboxes has an up and
down arrow keys to increment or decrement the value and the function that
does this is in a general module.
Is there a way to make all these command buttons's afterupdate to run the

I found the following page
(http://office.microsoft.com/en-us/assistance/HA011730581033.aspx) to show me
how base one combo box on the selection of another.  (i.e.  When a TYPE is
selected in combobox 1, only associated SUBTYPES appear in combobox 2.)  This

1) I have 8 Combo boxes on my form each with 2-3 choices.
2) The user selects from the choices, for example:
ComboBox1: DSL will not sync Up
ComboBox2: White XAVI X7868r+

I have a record review subform in datasheet view which is based on a non
updatable query.  Is there a way to click on the record on a certain field
(I'm hoping for the yes/no field but willing to use any field on the record)
to update the underlying table.  The source query is ...

I have a form that has Name, Date and various other fields in it.  The Name
is automatically filled in from the user's logon name and the date is
autofilled too.
Problem:  The user enters data, then hits a button taking them to a new

There was a KB article that shows how to use a textbox on a form to select an
item in the listbox.  As the user types in the value, a matching value is
selected in the listbox.  I cannot find that article.  Does anyone know where
it is?

I had this working in Access 2000 prior to my PC crashing.  Now it errors
when it tries to declare objPrinter as printer (User-defined type not
defined).  When I change the declaration to a String or to nothing, it passes
by the declaration and errors on the ActivePrinter part of ...

Is it possible to have the ID field (autonumber?) in alphanumeric
sequential numbers. (e.g.
DMC001,DMC002,DMC003...........DMC120.....etc). The reason for this is
that I have two parallel databases running and want to be able to trace

Good Morning,
I have a form that is opened from the seitchboard in Add Mode. In this form
I have a combo box that looks up records in the form. This combo box doesn't
work in Add Mode therefore I don't want it to be visible when the form is in

Hi,
I have a problem to get infomation of ALL CONTROLS from all forms in a
external DB (Not linked)
My code is: