Maybe I'm missing something really obvious, but I'm struggling to find an
event on my main form that precedes a subform Current Event when I move to a
new main form record. Does such an event exist?

I have a function called fOSUserName, that I found, to get the login name of
the person, when they open my main form.
code:
Private Declare Function apiGetUserName Lib "C:\WINNT\system32\advapi32.dll"

The Enter button on my form works fine as far as entering the information in
the fields. What I would like it to do is not only enter the information, but
clear the form for new entries.

I have developed a form based on a query that prompts users for criteria.
If no data is available for a particular criteria an un enabled / blank
version of the form opens up.
How can I slot in a Msg box tha says no "No Data for this selection) and the

I have a form with a subform.  The subform records guest stays based on the
guest in the main form.  I need to be able to add data to another table that
records information on who to invoice if the guest is not paying.  For
instance a company paying for the stay.  I was hoping to ...

Tab events in office xp don't work, i try a on click procedure one one the
tabs and nothing happens.

Is there a reason that [controlname].Requery doesn't work in an ADP?  To
requery a list box, I need to reassign the Rowsource in code.  Is there a
way to use the Requery method.  This is causing me a lot of problems for a
procedure I am writing.

What's the preferred way to simply switch between two open forms that are
maximized?  I've heard that the form visible property can be used, whereas I
was wondering if the SetFocus property of the form wouldn't work better.
One caveat, Form 2 can be accessed from a number of other ...

An old thread re-visited......... (I have a new twist
on an old problem)
Does anyone know how to obtain the name of the
current user's e-mail client? E.g., "Outlook",

How do I retreive data from a table, using sql, based on entry in form?

I noticed that my Min/Max/Close buttons on maximized forms have disappeared.
The Access application Min/Max/Close buttons, however, are still present.
These maximized forms have the following settings:
Control Box -- Yes

I have a subform in continuous forms view (i.e., multiple records are
displayed on the subform).
If this were a report rather than a form, I could create a textbox control,
set its control source to "=1" and then set the running sum property to

I have a form that lists a dozen or so reports.  When criteria is specified
in filter fields provided, a WHERE clause is written so that when the report
opens, only the filtered data is shown.  It all works fine but I have just
discovered a problem.

Ihave this NestedIF statement that doesn't seem to be working.  Does anyone
know why?
Thanks
DS

Is there a way to edit a form while it's closed?  I would like to be
able to edit the properties of some of my forms & reports w/o actually
opening them (and thus causing the sql to fire.  If not that, then
maybe some way to open them silently so I can set properties, closing