I am trying to perform a search for a record based on a text box value in a
sub-form. I keep getting run-tim error 2109. Can't get it to work. Any ideas?
Thank you?
The debugger says I have a problem with "DoCmd.GoToControl ("pkglotnumber")"

On my form I have an button to Browse my Computer and an Open Button
that allows me to open the file I have associated on my Computer. The
browse button also places the name of the file into a a field named
tbFileName on my form.

could you get the right answer for the following Question Pleas!
I have three forms Main form (frmMain) and two sub forms (frmSubform1 and
frmSubformw)
I want  

I have been entering info in my form with no problem. I closed the form and
went to something else and then came back to the form. I noticed that Access
saved what I typed even though I didn't tell it to. This is also a problem
when accidentally editing an existing record. I ...

When I perform searches, I only need to search from one feild. Is there a way
to costomize a search to defualt to the field that I always use. I have known
others to create a customise search form...but don't know how to do that.
Thanks.

How to perform the following:
On a form I have a series of dates which track movement of customer
Containers.
I do not want a user to enter one date until the previous is populated:

I have a table called tblMemberData, which has an autonumber/primary field
called “ID” and several other fields.  A second table, called tblDirections,
has two fields, ID (number) and Directions (memo field).
I have established a one-to-many relationship between tblMemberData and

I've been working on this for about a month... but i've hit a wall...
I've set up a form (Mainform) that will display information gleaned
from a query (Mainquery) on a database. One piece of information
Mainform pulls from the query is a log of activity, which is placed in

I split the database and created a new table in the backend part.  Then when
I went to the front end to create a new form I don't see the new table.  How
do I get it to show up in the front end?

In VBA, how is the position of an option button determined? VB.Net would be
if  testRadioButton. checked then...............
or in the case of check boxes....if checkbox1.checked = true then........
I do not see these available or am I missing something.

I just changed a checkbox for a Y/N field in a table to a combobox where one
can check "Y" or "N".  Now I can't check either option button in the combobox
and cannot see any data from the table.  I did notice that the data in the
table still displays as if it came from a check ...

I have a form where the user can enter a start date and an end date
into two textboxes. The default for both textboxes is today's date.
The user can then view or print a report of transactions between those
two dates. I would like for the default to be the current day's

I was wondering if there is a way to spy on an Access 2002 form.  I am
trying to scrape data from a form into my app, but Spy++ only shows the MDI
client window and not any controls in it.
Any ideas?  Thanks very much.

I'm running the following code to enable / disable radio buttons, depending
on certain conditions. However, I  get a type mismatch on line 5. I've
declared meterfind as an integer. Is DLookup returning an integer? If so, why
the mismatch?

I love this calendar but there is one change I would like to make. The
calendar (in form view) gives the user access to change the properties of the
way this form appears.  Since I can't change it in design view how would I
delete this option AFTER I select the settings I want on ...