I have frmMain with 2 subform (frmSubForm1 and frmSubForm2).
Is there a way to check if a subform has record before allow user to save?
SF

Hi I have a tab form with 4 pages.
I need to tab out of the field Occupation on Page Customer Detail into the
field EmployerAddress on Page Employer Details.
The main for is called Incident Data Entry

Hi, I have Access 2007. I have no idea how to write code for Access. I know
how to create a database as far as the tables, forms and reports, but that is
as far as it goes. Is there somewhere I can go to find out how to do this? I
have searched the microsoft web site, but I can't ...

I made a form to look up 3 table fields. What I have is a table with a
filter section of items;
field 1 is GROUP
field 2 is CATEGORY

I am running Access 2007 and I have had this happen to me in the past with
Access 2003.  From time to time, when I open my db and open a form, it will
automatically resize itself, either by maximizing or reducing it to a very
small size (approx. 1/8” wide by ½” high) and it’s ...

I post a question a couple days ago in microsoft.public.access.forms, and I
didn't get a reply.
So, here I'm asking that question again.
I have a form, say frmB, that I open with acDialog option.

I have a help desk form that needs the very next number to show in the help
desk control source text field.  I am trying to pull this number from a table
so the help desk form can support more than one user simultaneously entering
data.  I started with a table that starts with ...

Hi all,
is there anything about the code below that would make access crash?
Private Sub cboStreetNames_AfterUpdate()
   ' Find the record that matches the control.

If anyone can help, I would really appreciate it.
There is what I want to happen:
    The employee clicks the incomplete checkbox and the Comment input box opens
up.  This happens.  As long as I enter a value this process works and the

I learn that unbound form has better performance and have an unbound
application.
I just realized that I need write SQL for insert, update, delete and
search SQL for every unbound form.

I have a simple form that describes a structure. The structure has a ID
number like "A-1". In the main table I've called this field "Struct_num".
This structure can have one or more "truss" sections. On the main form the
user enters the number of truss sections in a text box. For ...

I have been searching all day for this but I just can't seem to find the
answer. I'm sure it's insanely simple but I'm just not getting it. This is
what I would like to do:
1. Have a button that says "View record"

In a query that I have, I have three input boxes where upon running
the query the 1st input box appears and you type what you need in it,
then the 2nd appears, etc then the 3rd appears then the results
appear.

I have a command buttons for reports that emails them to mutliple users.  I
set up a table of email addresses.  Since I may need to change these from
time to time I have set up a form so users can make those changes themselves.
So, the email addresses in the "to "and "cc " are ...

Is it possible to trick the MsgBox prompts for a vbYesNo question to
something else rather than 'Yes' or 'No'?   In other words, the
options remain the same, but the MsgBox prompts are turned into
phrases like 'Wicked!' for Yes and 'Get Over It' for No...