This seems to be a variable scope problem.
I have started using a particular technique for developing Access
interfaces, but it has resulted in seemingly odd behavior.
My main app form consists of a tab control with a tab page for each major

I would like to implement a BeforeUpdate Event in a field called "job".
When you open up the form for the Jobs, you see the last job entered.  
People are typing over the last entry when they are trying to either search
for another job/or enter in a new job. There is a button for ...

I have a form that has three command buttons. On the OnClick of each button
there is a procedure that runs that checks the input, pops up messages if
are errors and then each procedure runs a query that is dependent on the
previous procedure and query having run before it. I want ...

I have a main Form (FormA) which is bounded to TableA. FormA contains a tree
view  and a subform (FormB) which is bounded to TableB
The tree view contains a list of products organised in different categories.
When the user select a product from the treeview, the productID of the

I am working in Access 97. I am trying to export 4 fields to excel. How can I
keep them in the same order/sorting they are in, in access. the order and
sorting keeps getting messed up every time I export to excel. The number of
records is usually 30 to 50 rows.

I am trying to figure out how to make a button check to make sure that
a selection has been made on a combo box and that text has been entered
into a text field.  I do not understand how to code this.  If anyone
could help me out with some simple code that would check for this, I

i build an application and in a form the user can add new record
while the user typing a new value in filed i want to show him values
reside in the table that match
the char's he already enter

i am creating a database for "Construction PROJECTS"...
it goes like this:
I have a form where a user can filter REPORT to generate using different
attributes like LOCATION, BUDGET, START DATE, END DATE and PROJECT STATUS...

I have a bound (NOTE) text box on my form txtJob_activity, to my clock_table
in the Activity column. I'm able to update everything else on the form but
can't seem to get this text in the box to update the record.
Here is my code to update via a button:

have inherited an unbound Form  on which one control is a combobox of
Customer ID ....
would like to add subform so that when a CustomerID is selected a subform is
made visible showing that Customer's address details.  subform can be bound

on an unbound form there is the header
and then in the detail section there are  a set of 5 buttons
beneath them in the details section is a tab page arrangement
was playing around in adding another control/subform to the first tab page -

Hello, I have a subform embedded in a main form, and I would like the tab
order to go from a check box option group to this subform and then back out
to the main form.  This works great when I access an existing record via the
form(s)...however, when I go to add a new record, I get ...

I have a form which is the basis for a report.   On the form I have a
list of facilities in Combo38.   Then, once a facility has been
selected, there are six choices in a frame to further filter down the
records.

I dont know if this has already been posted on here, but i am really stuck
and have been searching for ages for an answer.
I have got a form where a customer would enter their membership number into
a textbox, when they hit the find button, i want the sql to find the record

I've posted this question before with no luck, so I'll try again!  I have a
subform within a form, which is basically a task list. Users of the form may
want to add a blank row in order to add a task which they might have
forgotten.  I would like to add and "Insert Row" option to ...