I have the following code in the after update event of a check box for
some reason the change to the text box is not happening until you tab
past the text box.
Private Sub ckbxoffer_followup1_AfterUpdate()

The CancelRequest procedure below displays the values that are present
in tblSelectMainReport.  I  want to "collect" all of these values, and then
display
them to the user so that he/she may select one of the values to cancel

1) I have setup a form, but I need to ensure the users complete certain
fields and not just tab to the next field.  I have tried setting up a macro
with a msg indicating this field can not be left blank, but I can not figure
out where to set it.  It does not have an option for ...

Dear Sir
1) I have Combo Box on the forms..row source type is vaule list..it has city
names of te world...now i want if user add new city name in the combo box it
shud be added in the combo and as well as next time if user comes to next

I am having problems with the dirty form property in Access 2003.
I have a database originally written in Access 2000 that has an On_Dirty
event that enables a certain command button when changes are made to the
form.  In Access 2000 this works fine when you either enter data ...

I often have forms with (too) many textboxes.  To assist users, I
prefer to change the back color of the textbox when it has the focus.
It is easy for the User to locate where they are on the form.  However,
coding each textbox's GotFocus and LostFocus event is very tedious if

I am having problems when submitting values from two combo-boxes in a
form.
I am a novice to programming in access and I would be grateful for any
help that I can get on this problem...

How do i reset a form and it's properties to the state of first being opened
without closing and opening it. The form is used as a sub form. If not how
can the saved property values be found.

I have a database that goes out and periodically checks for new CSV
files to bring into the database. If there is, it imports that text file
into a temp table, deletes all records in the permanent table, copies
the info from the temp table into the permanent table and finally

I have a report dialog where users can select a date range, then choose
from six different categories in an Option Group.
Example, date range 1-May-05 to 20-Apr-06 and "Leadership & Management"
chosen from Option Group [frame9].

On my form, I have a "Save" button which is used to save the current
record.  I believe that it is not necessary to save the record, as it
will be saved automatically when I move to another record, or create a
new one--perhaps someone can clarify this for me?

I am hoping to get some help on trapping this error, or finding a
workaround to avoid it.
I am getting the error "You tried to assign the Null value to a
variable that is not a Variant Data Type" when working in a subform

I have a control on a form where I change the StatusBarText when AllowEdits =
True. How do I retrieve the default StatusBarText when AllowEdits = False?
Description (in the table definition) does not seem to be available as a
property for the underlying field. Is there a way to ...

I'm using continuous forms to match as close as possible an excel file. At the
end of each day, I export the day's info to this excel file, which is then
emailed to a business which requires excel files.
(just trying to explain why I did it this way in the first place)

I would like to set the property of a continuous form subform based on the
value of one field on the main form.  If the value of [Submitted Date] is not
NULL, I'd like to allow changes but no adds to the subform on one form (Form
A) and I'd like to not even allow changes on ...