I was wondering if you want to insert a bound picture but when there isnt a
picture and the value isnull, you want the text to read "No Picture" what is
the statement you can use:
I currently was thinking:

I have 2 fields in a Form – one for Event (Combo Box) and the other
Event ID (Text Box).  How can I have the Event ID field populate
automatically when an Event is selected?  How would I need to
structure the tables to accomplish this?

i have a cascading combo box that populates the field: txtname on form based
on the final material chosen. (this material comes from a table that has the
material name, id, supplier)
my question is how can i also automatically populate the field txtsupplier

I have a form with a couple of subforms.  The textboxes on the subforms are
set to visible = false.
Sometimes when I close the database and re-open, the subform textbox
properties have been re-set back to visible = true.

I have a form which includes a column where the user selects a tick
box and this automatically fills in there name and date on another
part of the form. The problem is if I tick say row 1 the name and date
appears as it should in row one but also ticks appear in the tick box

I have a form that our users fill out and then will have to email.  RIght
now I only have one object on the form emailed to me.  But I would like the
whole form to be emailed to me for that current record.  Is there any way of
doing this?

Hello all! We are upgrading to Access 2007. When I try to make a new form and
use AutoFormat, or edit one such as in the Northwind example DB, I only get a
solid color(and not even the one in the format), not the format or design I
chose. I have tried this on multiple machines ...

I am trying to create a form for forcasting.  I want to, try to anyway, have
a picture of a funnel that changes as the sale moves through the sales
process.  Does anyone have any ideas?

I have a simple combo box that is taking its row source from a newly created
table that has only two colums - the key (just a list of continuous numbers)
and a list of surnames.
No matter what settings I try I can only get the combo box to display the

Is there a maximum number of field that can be put in a form? I created a
form from a query, but there is no field is visible in the normal mode but I
can see them all in the creation mode. Any solution?
PS: I do need those fields  :)

I have a Main table with over 100k existing records, and one field
(ClassName) has many repeat entrees, so i want to creat a lookup table for
that repeat field.  The lookup table should have a primary key field named
ClassID and a second field named ClassName.

I currently have a query called qryDetails, and form called
frmWhatDates and a report rptDetails.
The form frmWhatDates has 2 txt boxes StartDate and EndDate and also a
combo box cmbCatergory. This allows users to select the criteria for

I have a form set up from a Table.
I would like to add and print only the new information on a regular basis.
The form has 3 Yes/No boxes with one checked on each record.
When I go to print individual records the yes/no boxes are no longer visible.

I have done this before, without using any coding (just the property sheet in
Access), but can't remember how to do it. Hope someone can help.
I have two forms linked. I have a main form, with a button on it to the
second form. I used the Wizard so that only the related records on ...

A couple of days ago, I finally figured out (after many years of using
Access) how to change the default properties for controls, so that when I add
a control, it gets created with the font, size, height, and other properties
I want.  I cannot believe it took me all these years ...