I would like to place a buttom on a form to delete a record. I would like the
user to be promted to whether or not the really want to delete this record.
Any help would be great.

Is it possible to refresh or requery a page within a form? Something like:
forms!FrmName.PageName.refresh

I tried asking this same question yesterday but as no-one replied, I think I
need to re-phrase it (it’s very difficult to explain it with mediocre
knowledge of Access).
This is the situation:

Ok I know that this should be pretty simple but I'm losing my head over this.
I've seen examples of people checking the value of a checkbox in more than
one way, sometimes like CheckBox = True, CheckBox.Value = True, CheckBox = -1.
Just as a test I have one checkbox created on my ...

I have an Access 2003 database.
There is one field which must always be all uppercase.
I have just discovered that about 3500 records have been entered in
mixed case.

I have a command button that will open a particular PDF file.
Is there a way to have it open a file for that current record without having
to browse?
I am thinking I would name the file the same as the reference #, and then

Is it possible in forms to display records in the following type of format?:
 Record1      Record4     Record7
 Record2      Record5     Record8
 Record3      Record6     Record9

Is it possible to set a margin on a combobox control, much the same way you
can on a text field control?  (so the text in the combobox doesn't crowd the
left edge.) The margin settings don't show up in the properties of a combo
box...could they be someplace else?

I have a main from on one tabbed page and a "daughter" form on the
other. If I select a record on the main form, can I then switch to the
second tab page and add records so that they are linked to the record
on the first tab?

How do I show the actual selection (data) in my table instaed of the ID
number associatied with the selection. I know there are ways but really need
help fast on this one.
Thanks again

I have a data entry form consisting of one main form (Client List Table) with
three subforms in it (Primary Training Table, Secondary Training Table, and
Employment table).  I have everything working but when I click on add new
client, the combo box I created in each subform ...

I built a databse with a main form for data entry.  This form has 3 subforms
and included in the subforms are combo-boxes with a table linked to them.  
When I click on create new record, every field is refreshed except for the
combo-boxes, they still have the same information in ...

I find this to be a rather ridiculous issue, but I can't seem to get the text
in a text box on a form to display when I set the Vertical Property to Yes.  
I'm using the Office XP 2002 version of access.  Does anyone by chance know
if there was an issue with this particular ...

Using access xp
I have a form with a form header section, a detail section and a footer
section.
For some reason, when the form opens it opens with focus on a control in the

I know it should show a number from a cbo selection in the table but how do I
show the actual selection (data) insteaad of the number from a cbo selection?