Hello.  I am using the following code in a form in OnCurrent and
AfterUpdate field.  However, when it is initiated, I receive a debug
error.  Any idea what I am doing wrong with this or how I can change
it to make it work?

Is there any way for a Date field to pull in the last time the
currentuser created a record? If so, can this field be edited (want a
different date other than last time record created)?
Also, if this isn't possible is there a way to put in a Calendar?

I get a type mismatch when I encounter
this statement:
If Len(HOHA(1)) > 0 And HOHA(2) Then Me.tbLn7 = "Cell(1) " & HOHA(1)
The highlighted area in Debug is:

My middle wheel of my mouse does not work on my VBA module code only.
I am able to scroll any where in my offices and Windows application except
VBA module code.
any special setup for middle wheel of mouse for VBA module code?

I have an access database with about 10 forms
Every time I open a form I want it to open in a maximized full screen state.
When I select my Main Menu form as a start up form none of the forms
including the Main Menu form open maximized.

I have a Table that includes the field "FileLocation" which contains the full
file name of various JPG files.
I wish to preview those files on an Access Form but I do not wish to
manually insert the protographs one-by-one: rather I wish the photo to be

There may be many thing wrong with this, so I apologize from the start.  I
have one form that builds the reference number, and I want to transfer that
and other information to the Main Input Form, and then move to that record in
the Main Input Form.  Right now, the form opens to ...

I have an option group. I can't seem to tab from one option to
another. Am I doing something wrong?
Also, I have two check boxes next to each other. I don't want an
option group for these two but would like to be able to only select

I have two fields (text boxes). Text box 1 is a Location and always
has data inputed. Text box 2 is an Sub Location but only sometimes
gets data inputed.
I would like to be able to pull up that if Text box 1 is being filled

Access 2003.
I am trying to create a customized graph that displays a variety of
information on a single page (this will actually be on a form and a report).  
I want to be able to create controls (lines, circles, boxes, and other

Hope this makes sense.  I have about twenty forms that link to various other
mdb's and ss's.  I made a public function to load the forms in a certain
order when you hit Enter or click a cmdbtn, ie, form 1 closes and opens form
2, etc, named Advance_Click.  Runs like a slide show; ...

I have a form (frmCaseInfo --> tblCaseInfo) in which client case data such as
ReferralDate, StartDate, CloseDate, etc. are entered.  I have another form
(frmContacts --> tblContacts) in which contacts such as face-to-face
meetings, phone calls, etc for clients are entered.  I ...

I have a form contains a sub form and a search button. The sub form is a
single form displaying a record from a query one at time.
If I want to search a record from the query and display the retrieve the
record on the same single form using the search button. How can I do it?

I have a huge database with multiple forms and subforms.  Two of the forms
are very huge and have 800 controls in each.  I know access have limitation
on number of controls in a form which is 850.  I do many enhancements to the
database and I am sure I will be reaching the number ...

Dear Friends
Please guide me how to change the focus from control from parent to control
in the child  form
After I press tab child forms control must get focused