I would like to use a checkbox, that when checked will place a value in a
textbox. I would also like that when it is unchecked to remove the value. I
have tried using an if then structure in the on_click event for the check box
to as yet no successful results. Any ideas???

I am working on a project that requires me to be able to enumerate
through all the controls that may be selected (ie: showing their
selection handles) in a forms design view window.  I have managed to
capture the active form and can iterate through all the controls on the

I updated from Access 2000 to 2002 and now I get this error on something that
has been working for years.
Here is the code!
           Dim db As DAO.Database

I have a simple 2 column combo box that returns data from a single table
sorted ascending on both columns. Both columns contain ID numbers and column
2 is the primary key for the table. Column 1 can have duplicate numbers and
column 2 is an autonumber (unique) . When a selection ...

I have an order form that contains a credit card number for payment. Each
order may have more than 1 transaction with the same card, so there is a
order.payments.subform.
I have a button that opens a new create.charge.form that handles the actual

I am trying to create a form that has a drop down list for state and city.
But I want to only show the cities for that state. Example: if I choose GA,
the next dropbox will only show all the cities for GA. Should I create a
different table for each state? Or should I create a query ...

I want to count the number of fields in the Bank Deposits record.  It did not
work on the upgrade.  I have been guessing at code for 8 days so this is what
I have at the moment.
           Dim tblName As String

I have a program with a parent form and two subforms (subform A and subform
B), each subform is located under a separate tab.  In subform B I have an
unbound txt box (txtweight) and also a command button to run a report.  In
subform A I have a ‘weight’ field.  I’ve written code ...

The form contains 11 tabs. Some tabs contain subforms. On a tab that does not
contain a subform, unbound textboxs are used to hold the captions for the
various controls on the tab. These 'labels' are displayed correctly on the
form and display correctly when in print preview. ...

I have a form that opens automatically when I open the database and I am
getting the following error:  The expression on current you entered as the
event property setting produced the following error: Module not found.  I
can't figure out where to back track to where I changed ...

Hi, i have a field for the open date on the purchase order, and the close
date, if the close date is blank I want it to say ON ORDER in the turnaround
time field, otherwise I want the amount of days between the dates.  The
following code puts in ON ORDER when close date is blank, ...

I recently created my first ADP application and I'm converting my old MDB
forms, reports so they can run in my ADP project.
In my MDB app, I used the below code on the "Form Open" event to change the
title bar, but I get an error when I try to run it in my ADP project saying

On a continuous form, can I vary the control tip text based on the contents
of a row? I need to do this for only one column on the form?
I would like to be able to do this whether the row is selected or not.

I have a public Function stored in a module "MyDates" that stores the fiscal
year, which is used in several forms and reports.
Public Function FisYear() As String
FisYear = DLookup("[FiscalPeriod]", "Dbo_AMC_Info", "[ID] = 1")

Hi,
Trying to work out with an undo button I’ve noticed that when in a record  
the record sector button is focused the undo function is not yet available.
Is there any event triggered when the record selector is focused as it will