Sorry for this question.  It seems to be well covered but I quess I'm thicker
than most.  I am trying to set a text box to nothing - Blank - Null.  I
thought I understand the difference but here goes.
My code looks like this

I've created a DB with a main form and on this form I have a tabbed box with
subforms on each tab.  No issues!
I have a switchboard that allows a user to get to this main form and other
forms to add specific data to tables.  So far no issues.  

there are 2 forms (main & sub)
when i make a new record in main form,
the new record is not yet saved / created in table
then i click the sub form button (by macro - openform) for creating

I have a problem in my Find Form that when I chose by Last name, it won't
work, I have to go to option 2 by Fist name, then to by Last name then it
works.
Can anyone help me how to solve this problem?

I have a time field which I have formatted to medium time eg 07:00 AM.  This
is OK until you click on it to edit the time, when the date continues to
popup.
In the time control's "on enter", "on click" and "before update" events I

I will have a minutes of meeting table as follows:
1. Autonumber
2. Decision number
3. Date

I made a test making MDE, and I see that Datasheet view also is disabled.
How can we make it enabled because it is important to see the records
horzontally, like in excel. Is there anyway to make it enabled in MDE?
Thanks in advance

I have this code on an onclick event of a command button to open a form:
Private Sub Command0_Click()
Dim stPassword As String
    stPassword = inputbox("Enter Your Password")

I have a form, that a couple people use. Can I take the below and lock two
fields instead of 1? The two fields would not always have data in them at the
same time. One person opens the form, does their work, then another person
does their work and closes it, I want to be able to ...

I need users to be able to pick a file from any directory on their hard drive
or on the network.. i basically need a <input type="file"> from HTML, but on
an ms-access form.  Can anyone tell me a good class to use for this?
thanks

I have a form to which I am trying to add a subform with a subform.  
If I look at the table in the datasheet view, it works properly.  Each level
(I have a Maintenance Report, Maintenance Info, and Maintenance Detail)
allows me to look at the next level below it (with the little ...

I am afraid I am a little rusty WRT MS Access (the last version I used
was MS Access 2000, and THAT was only to fix to referential integrity
problems and create additional queries for an Access app that someone
else had created and couldn't fix).  I am presently working against MS

In developing this form, I created a bunch of check-boxes with "Yes" as their
defaults. Let's say one is called 'PCA_L' and its label control were called
"label37". I have 'discovered' that when I click in "label37" the effect is
to 'toggle' the check-box's value to the other one ...

From the Access help, it says that you can use a select statement in RunSQL.
My question is, how do you get the values of that select statement? For
instance if I select a dropdownlist which lists columns "ID, first name,
middle name, last name", is there a way I can make all ...

I have a form that allows the input of personell and their
supervisor.  I use the same table for both the supervisor and employee
and just update the field supervisorID to match the primary key of the
table.  However, on the form I want to show the Supervisors