The following  code is not working
Private Sub Label24_Click()
IIf(Me.PostDate.Value Between Me.RecDate.Value And Me.DespDate.Value,
Me.PStatus = "PostAll", Me.PStatus = "PostLater")

I would like to use the 'Close' command so that it does NOT save any data
entered so far on the form.
I have frequently specified   'DoCmd.Close,,Save No',   or sometime
'Prompt', but to no avail, the data on the form is SAVED - always SAVED.

I would like to put code behind some <alt> keys in a form.  I am assuming I
can put it on the Key_down event.  Then I should check KeyCode like:  
If KeyCode = vbKeyTab then
    Do something

I have a many forms with numerous option groups and their values, which
I then put into bookmarks on a Word document.  Each option group is
named optNAME1, optNAME2, optNAME3, etc. and each bookmark is named
Bkmrk1, Bkmrk2, Bkmrk3, etc. I have created a button on the form which

I have a very weird case, which I have no idea how anything I do could be
causing.  So, I'd wonder if it seems like an Acccess bug and whether there is
a workaround.
I have a form, which is a continuous form with a number of unbound controls

I am trying to compare a employee code that is entered into a form with a
list of existing employee codes to make sure employees are not entered twice.
Using the On Exit event I am using a bit of code I found in Access’ help:
Private Sub ServiceNo_Exit(Cancel As Integer)

Hi All - I am developing Video Rental application. I want my client to click
on Customer form and at the bottom of the form I have several buttons. One of
the buttons is search. My client can here either enter a new record or else
can just enter either First Name or Last Name or ...

I had 2 tables
tblinventory
tblIssuelines
fields are

If this is off post please direct me.
I
am having problems understanding how to make a MsgBox with more than
one line in the statement.

I have a button on a form, which I want to make visible only when the subform
"disappears" if a user deletes all linking records in the subform.  (The
record source of the subform is a table in a many-to-one relationship with
the source table of the form..)

Problem 1
I have a Tenant table that is linked by a CustNo field to a TenantNotes. Now
the TenantNotes has 4 fields as follows:
CustNo

Win xp and Access 2003 - I have a report called churchreport based on a query
called churchquery (which is two tables joined).  I have list box on a form
called countryselectform with the list box called lista2.  In my report I
have a grouped field called districtcountry.  The ...

private sub job_gotfocus()
do while isnull(job)
msgbox "value is must here"
exit do

I have a Commandbutton.Hyperlink.Follow command in one of my forms.
When the document is Word, Excel, Powerpoint, the document opens once. HTML,
JPG documents open twice. I can't see why.
Any help appreciated.

Example:
Mainform
   SubForm1
       SubForm1A