This should be real simple but I don't understand the result so I can't
figure out the answer.
Three text fields:  Height, Width and Size
The afterupdate event for Width is:

Is there an acceptable alternative to using DLookup on a form/subform?
I have a patient listing with multiple transactions.  The transactions
are coded as to type.  I am now using a DLookup to populate a TextBox to
give English Descriptions for each code.  With 500 transactions ...

I have a subform that consists of the child entries relating to the parent
form. I want to make sure that data has been entered in this subform prior
to performing another function.
Is there a quick way to check the subform control to see if it contains

I have a table named "Application" that has lots of records that contain at
least one NULL value in a field.
What I want to do is "Find and Display" only those records that have a NULL
value in a field.

I am running an Access 2002 SP-2 adp that is connected to a SQL Server 2003
backend database.  This database has a non-default collation of
"Arabic_CI_AS".  I am continually encountering a "connection failure" error
when trying to open one of my forms within the adp.  The code ...

I've seen this "cbo" used in coding quite frequently. What is it and what
does it do?
I've tried using it to validate data in controls on my form, but it doesn't
work for me. Does it require a module be loaded or need some type of

I have a control on a form that I want to ensure the user completes before
moving on. It is a date control and I'm using this code in the BeforeUpdate
of the control
Private Sub txtMontha_BeforeUpdate(Cancel As Integer)

I am calling up another data entry form from my current form and that seems
to work but every time I try keying data in the data entry form it makes a
new record instead of linking to the main form. Please Help Me!
Button On Main Form

Is there any way to check which page has the focus when using the "Page
Break"?
TIA   Hal

Hi, I am getting a very frustrating error that occurs every time I switch
between “Design View” and “Form View”.  My form has a Sub-Form which at this
time does nothing.  Also, my form uses VB code which opens and closes the
database.  I verified that the database is being closed ...

I need to limit this recordset to one record selected based on the social
security number from another form.  However, when I use the following where,
it gives me an error.  
Dim workbase As CurrentProject

I'm attempting to seperate out 2 sides of a text string, representing an
exact foot and frame for a roll of film.  The size of the string is variable,
but most of the time seperated by a + sign.  All of the data except for the +
are numbers and I need to pull them out to multiply ...

Sometimes, not always I get this error when on this line in my Current Event
of a main form....
[PickUps].Form![ViewLogChanges].Visible = Nz((GetUserLevel() = "Admin"),
False)

Am having problems with the syntax of the Time section of
the following code. Can you help
If Not IsNull(Me![StartDate]) Then
           vStr = "[Date]>" & Me![StartDate] & "#"

I'm opening a form using the docmd.openform command.  It looks like:
   DoCmd.OpenForm "ZoomWindow", acNormal, , , , acDialog
I open it as a dialog to give a modal window, in other words, the user must
address the window and close before returning to the main window.  However,