How do I delete a click event?

I would like to create a form used to input data into a table.  The table
structure is shown below:
tbl:Mass1_Rock
StationID (fk)

I have a find button that I have set up to look in a particular text box. My
problem with it is that It is always set to find the whole part of the box
while I want it to look for any part of it. ie: I want to find a customer but
am unsure as to how it is entered exactly in the ...

Is there a common reason for a combo box not showing any values?
Is there something wrong with the code in the RowSource, below:
cboQstPtVal
SELECT tblQuestions.QstWithPtVal, tblQuestions.QstID, tblQuestions.[DM

I have a text box on a form in a 2007 database that does not behave as
expected when filtering by form.  Only the choices Is Null and Is Not Null
are available to me, rather than the entire list of values, despite the fact
that there are fewer records than the 10,000 record limit ...

I am running Access 2003.
Thanks to one of John Viescas' books, I've been able to add and
display an image on a form. Unfortunately, as soon as I move to a new
record in the form, then go back to the first record, the first

I have one form in a database that is giving me fits.  It will not open to a
'new' record for entry of new data.  I set the data dentry property to 'yes'
and it doesn't work.  I created a macro to go to a new record and placed it
in the 'on click' event on the form and that does ...

Good Day,
Main Form [frmDATE]
Sub Form [frmCOUNT]
On the subform ON Enter, I have DoCmd.Requery, which works fine after I

I have a form to add new info. and want a field "empcode" to be auto
filled base on the Name selected.
I have the code on the After Update Event Procedure below, but it
didn't do anything.

I have a form with a tab control and a subform on it.
In the subform I have text boxes which have text that can exceed the size of
the text box.  I set the form's properties so that the detail section Can
Grow = True as well as the subform's Can Grow = True in the parent form.  ...

I recently created a main form in the style of the customer order form in the
Northwind database. It has two subforms and I've linked them together so when
you click on a line in the first subform, the relevant records appear in the
second.

I have a simple database but a problem I can't figure out. Objects
are:
1) Table A.
2) Form A, used as a front-end tool for data entry for Table A.

Compact on close has to be set by database. I have a bunch of databases for
which I would like that to be the default as well as new databases. As of
now I open the database, set the option, close the database. I am not
comfortable compacting using tools, compact since it does not ...

I have just solved a serious problem when trying edit a form in design
mode.  Basically, if I try to copy a label or text or anything at all,
when I try to save, Access just plain out quits.  I did not see any
specific error on the use groups that addressed this issue.

I am just setting up a brand new database and am building the forms to be
used for data entry, editing, etc. Since all the fields will be needed on
each form is there any reason to base the form on a query of all the fields
in the table rather than just using the table itself? If ...