I want to create a form where I can select multiple values. I have
Table “Chemicals” that contain 10 chemicals say C1 to C10. I have
another Table  “ROOM”. I have setup relationship between “Room” and
“Chemical”.

Is this right?
Select Case
   Case 1 To 4 or 6 or 8 or 10
   Case 5 or 7

Below is a piece of code I am working on.  The issue I am having is that if
there is a recordset error, specifically if the the value in iBox does not
exist in the recordset, there is your standard 'Not BOF or EOF' error.  If
that error exists, I will have a msgbox popup stating ...

I'm confused about what happens when I do a delete of a row in a recordset
that joins 2 tables. Does this attempt to delete rows from both tables or
only one table? I'm getting an error indicating it is trying to delete a row
from a table I dont want it to. Here is my code:

If I have warnings turned on like in the code below, the insert runs fine,
although it interupts the user to push OK, but if I set warnings to false,
it's almost as if it just ignores the insert all together.  It's doesn't make
alot of sense to me why it would make any difference ...

I have a Purchase Order (PO) Generator that allows my users to add anywhere
up to 25 items to an order (using individual subforms called up from the Main
form). Sometimes it's easier to copy the current record and make a few little
changes to any of the items, then it is to retype ...

I have a form that uses a drop down box to select the system.
Here is the code for that box (it works perfect)
SELECT [qurEupipEmp].[IDTag], [qurEupipEmp].[FullName],
[qurEupipEmp].[LocationDesc] FROM qurEupipEmp ORDER BY [LocationDesc];

Help I am new to this and although have basic idea do not understand coding
enought to do what I need.
I have 2 tables - project details and property details
One form has been created from a query based on the two tables above.

I need to open a new form that shows records with partial field matches to a
field in the original form. So far I have:
Dim stDocName As String
Dim stLinkCriteria As String

Hai,to every one
here is my question
I have designed the coding to collect the feedback report from the user
,which includes Name of the user, staffno and comments.But when I click on

I have a subform based on a query that will not allow me to edit the data.
Does this mean the query is not updatable? Is there a way to confirm this? My
query is:
SELECT TD.*, DT.*

Any new OS or version of Access usually makes my database unhappy.  Often
the cause is CommonDialog or another of the (to me) mysterious things
working in the background.  Giving someone a copy to use on their equipment
is often a waste of time.  As far as possible, I'd like to

I have a form with a listbbx and both are based on the same table.
I want the listbox and form to display the same row when I make a
selection in the listbox.
I'm populating the listbox with dvd titles and have placed the movie

I'm an experienced Access/VBA developer, but I've never seen this odd
behavior before.  I've got an odd issue happening with one of my
comboboxes on a subform.  When the form loads up, it works fine, but
on a requery the column(0) - column(x) values of the combo box become

Can I customise/place my own commands/event procedures on the right mouse
button? For example, I want to be able to send an email by selecting a field
by  right clicking and then hit my 'send email' procedure.