I have a combo box that should goto a record on the form based on the
selected value in the combo box.
Right now all you get is type mismatch error.
Here is the code in the combo box.

Well I was getting overconfident and thought I could get this to work.
I have a Combobox on the mainform 'Combo2'.  The user is meant to type a
date into this feild.
The subform is a datasheet form with a feild called [date].  I attempted to

   If DCount("[Style_Name]", "Styles", "[Style_Name]=' " txtStyle & " ' ) =
0 Then
             ( return wrong)
             (do sth.)

I have a form that searches a query based on zipcode. I then need to be
able to Filter the report by a selection. (it won't the the same each
time.its based on what populates by the ziocode search)
I can make a command button but can't get past this:

I have several forms which constantly get entered several times causing me a
huge problem with duplicate information.  I want to create a warning pop up
message which will warn users that a record already exists and prevent them
re-entering it.

I have an ADP to an SQL database. On a form which shows about 13,000 records
I want to navigate to the last record the current user created, no problem I
just add some code to run in the Load event e.g.
   Dim rs As ADODB.Recordset

does anybody know the error number associated with the error "Microsost
Office Access can't append all the records in the append query"  I know why I
am getting the error.  I am trying to produce a certain message if this error
is encountered.  

I've a .mdb file with a lot of forms where i get recordsets through ado
from a external database.
The problem with the forms is that when a user has a particular form
open and another wants to open it, the following error occurs:

I have 2 tables:
table1-Customer - with customer_no, customer_descrip, parent_no
table2-Parent - with parent_no, parent_descrip
On my frmCustomer, I'm trying to display the Parent_name.  I've tried using

I created a command button to filter data on a form. However it doesn't
function. I do not know VB Basic at all. please help.

I'm trying to run this code on the main form load event.
If the Subform has no records then the Listbox on the subform is empty
otherwisw populate the listbox with the appropriate records.  It works
fine whenever there are records but when I open the main form with a new

Is there a way to prevent multiple sessions of the same access db from being
opened.  I have discovered that if a user has a db session minimized and
accidently openes another session of the same db problems with data are
showing up.

i have a table "Patients" which i enter info thru my main form .I enter
patients details and have fields like"Patient,personal no, Diagnosis
,consultant, hospital etc" some patients we send for overseas treatment more
than once .i have to have a record for each visit.

Anyone have an idea what this DLL is for?  We just got a sample database
from a colleague, and when we go to use it the following error occurs:
"Your Test database contains a missing or broken reference to the file
SBCMDWIZ.DLL version 67.0"

I want to clear all data from a form without running the onload event.
Here is the situation;
The form is used to enter date related to a specific training session
into a temp table after selected all the information that is needed