I have a form that has checkboxes for each certificate (there are 8).
The control source for each checkbox is as follows:
=IIf([Certificate code] In ("TDP0100"),1,0)
This checks to see if required certificate is complete, if so box is checked.

Access 2003.  ComboBox with physician names. To add a physician, double
clicking opens up the physician form.
Problem
If I enter a name that is not on the list to my combo box, I get a prompt to

I have a record with multiple publications. I'm tring the print a
report that will show the draws for Saturday if the publication is the
HC,WSJ or NYT and monday draw if the publication is BAR and IBD.
I've created a query that gives me all the right information, but

Is it possible to create a css style dropdown menu for an access form
If so, would you please be so kind as to share your knowledge.
There are some 3rd party applications which do this but all are quite
expensive.

Access 2000.  This expression has worked well for a couple of years up
untill now.(I received this from this newsgroup)   The only thing I have
done is change the format from number to text on the field [App_ID] of my
table [Account].  The App_ID field used to be strickly numbers ...

I am trying to print the information from a current form to a report.  I have
searched the web and tried using the different suggestions of code which,
begins with DoCmd.Open Report...but when I use that I am getting a message
that says this Macro has not been set up and I was under ...

Hello.  I have a table Schedule, with columns RoomID, TimeSlotID, and
SessionID.  I made a form with a list box for selecting RoomID, and a
subform showing TimeSlotID and SessionID.  So far so good.  But the
ordering of the records in the subform is not what I want.  

I have a next button in a form that I have criteria for.  I have a date field
that has to be entered before going to another record.  When I click the next
button I get the pop up that says click update to continue but the form
displays the next record instead of staying on the ...

I made the mistake of trying to get a little fancy and agreed to try some
code with help....but the help is out of town now.  I need help
troubleshooting my combo box.  I have 2 on my form.  One to look up patients
by last name and one to look up my patients by room number.  I am ...

Hi: I really don't know what to do.
I just want to make my form to a resonable size (not the full size) in
Access2007
But I just can't do it, and I don't knwo what is wrong, I have used previous

Is it possible with a combo box to have some txt in it that will say what its
for, which goes when something is selected, so kind of like a watermark.
So you open a form, inside the combo might say "select the name... " which is
there until something is selected.

On a form, I have a text box in which I want to enter a date. I want to
restrict it so the date entered is a Sunday. How can I do this?

My data tables are organized by "period" and "Year", I'am using a pop up to
enter these parameters and run a report, I would like to be able to compare
this periods data against last period. How can I display last period data?
thanks

I have a form where the top you select the store number from a drop down and
it populates the store information(address, city, state...) using a VBA code.
The bottom of the form has 10 rows where an employee name is put in one
unbound box and the hour worked in another unbound ...

I have a continuous form that I have attached to a query as a control
source.  If I manually put the fields in the table they show great in
the form.  If I try and add entries using the form, the next time I
open the form that entry is not there.  It is not adding the entries I