Below is a sample of code from one of my command buttons.  Each button
currently has this code.  I want to simplify the process by making a function
that the cmdbuttons can call.  However, the one section that is hardcoded per
button is:

I have a search feature on a main form where a user will enter a incident
number and it will bring up the record in a different form in order to edit
the data.  When I try to use the feature, it will only provide the "Please
Enter a Valid Incident Number".  The text box that I am ...

I'm getting an error msg below.
Record is deleted. (Error 3167)
You referred to a record that you deleted or that another user in a
multiuser environment deleted.  Move to another record, and then try the

I am quite new at Access forms and Access VBA. I have a single form which is
nearly completed that is built on bound text boxes.
I can fill the form with the information that I want to save and if i simply
use the tab key to move through each control on the form the record is ...

i want to create a new database containing below fields
processname
checker name
quater

I have the MAIN unbound form with unbound combo [Status1] on it.
Its row source is:
SELECT stStatus.ID, stStatus.Status FROM stStatus ORDER BY stStatus.Status;
(shows status, but doesn't show ID Number)

I need help with the following select case statement.
I am using an option box on the main form to filter records in the subform
and for some reason I am getting the above referenced error.
Here is the select case code:

I'm hoping someone can help.
I have a form with all the information related to leasing a motor
vehicle, in this form I have a subform which allows the user to make
comments which automatically inserts the date.

I have a form that I would like to do the following:
1. Have all new records open to add information
2. Have all previous records Non Editable (all fields are locked)
3. I need to make the previous records editable if the managers need to

have a button on a form (that opens a new form) to add a new shipper.
When the user clicks on the (close form) button, after entering in
data, the following code
executes.

I Have an update query that is updateing one table called MenuInfo...the
problem is that part of the criteria is based on a second table
MenuDetails.  The two tables are joined on MenuID...the problem is that
it's not increasing the ModGroupLevel1 field by 1.

I am trying to set up a vending data entry form with a cmdbutton grid from A1
to D10, with two fields below for data input for product sold (
[txtProductSold]), and product expired ([ProductExpired]).    IE:  You click
on button A1, then enter a number for product sold in ...

I have a search form that uses the user's input to build an SQL query
and then sets that as the form's recordsource.
I want to store the ID column ("histID") of the records I found in to a
table I created ("zTable") so I can then open various reports using

I am attempting to similate a already in-use generic outlook form in access.  
I would like to use 1 unbound form to save the data to several different
tables.  How should I go about this?

Hi!!, I need to update a field with a value correlative for example
1,2,3,4,etc... for all the records in my access 2002 table, how can I
make a query that can do this???
This query doesn't work.