I have a form with 5 subforms on which I'll call A - E
A is master to child B
B is master to child C
the 4 records in B have values 1-4

Folks,
  I realize this will be a tough question to answer, but I thought I'd give
it a go... perhaps someone has run into this problem.
  I use an old Ken Getz Access 2.0 custom Navigation Buttons routine that

I have a list box that is set for a single selection.  I need to change it to
a multiple selection.  my problem is I have coding that works with the single
selection and I
do not know how to get it to work with multple selections.  I have two

   This is kind of pointless, but I was told to add this to my
database.  I have a toggle button to represent certain approvals on a
form.  Everything works fine, but my supervisor wants it to be green
when true and red when false.  Seems simple, right?  Well I cannot seem

I have a table with the following values:
PatID TestDate Type   Value Range Na_Yes_No
2163 7/10/1995 NA  143    145      0
2163 10/2/1995 NA  147    145      1

I have a form setup that allows the users control certain search criteria.  I
am looking for away to allow the user to  place multiple selects in one of
the text boxes on the form.
Example would be Tax Id (999999999,999999998,)

Hello,
Below is the code I have in the Form Properties of a Form and on the Events
Tab in the BeforeUpdate area under that tab.  This code works great except I
need to say if the control is enabled = false then go to next control.  

I thought I new the function but can't remember. propercase?   Can you tell
be how to code a text box so it puts capital for the first leter in the text
field.  thanks,
edward keith

I have a routine that counts the number of new records.  What I need is to
place a “YES” in the new field of the tblAuditInput table if that record is
new.  The routine is appending new records to the table.  “New” is just a
flag to let me know that these records are new.

 I had a request this morning from one of the users of an Inventory system
I setup that is an Access app. linked to a SQL Server database.  They have
asked me if I could put a combo box on the form for looking up a stock item
no. from the stock table.  In other words, instead of ...

Hi again,
I would like to create a form that looks like the upper pane of the design
view of a table, in other words having record selectors, adjustable field
length, BUT above all, empty places for new records, it should look like a

Can anyone tell me if this is possible, and if so the syntax.
I've tried:
Forms!form1!form2subform.RecordSource = "tblabsence"
Forms!form1!form2subform.Requery

Hi, I have a form that when I check the deceased checkbox I would like the
form to either change colors or a msg box to pop-up.
I've tried
If Deceased = True Then

I have a form "frmParts" within which is a subform "frmToolAssems".
Within frmToolAssems are two combo boxes which can be filled either by picking
from the drop-down list in the standard way *OR* by double-clicking, which opens
one of two forms: "frmTools" or "frmHolders", depending ...

can you tell me why I get a messege "data type mismatch in criteria
expression."
I have a form called frmClient with a button "btnShowClientInfo.
The button should open a report in preview that gives me Client information.