I want to run the click event of a particular command button on the main
form - when I am on a subform.
I tried the following syntax but it does not work...
forms![frmMain].CommandButton_Click

I would like to invoke a procedure in Form A (modal and open) from Form B
(also modal and open). The procedure would cause a change in the data
displayed on form A. Is this possible? and what is the correct syntax to use?

Digging on the net I've the following article:
http://office.microsoft.com/en-us/assistance/HP051867611033.aspx
That explains object by object how events occur.
Unfortuantelly it doesn't explain how events flow when those objects are

I've set the form allow edits to false. How it allows me to edit?
--
???? ???????
roy@atidsm.co.il

Is there a way to limit the amount of characters in a memo field.

Hi if you have a table field with its required property
set to Yes and the field is not filled with data you get
an error on the form when trying to save the form.  I
would like to display my own error message instead and

My problem is as follows:
I have a form with a combo box (among other fields) which I also use to
check if the item I want to insert
to a table exists in the item register.(Combo record source is that item

I have two combo boxes on different forms but both called cmbmaincompany.
On form1 the the row source is:
SELECT tblCompany.cmbCompany FROM tblCompany ORDER BY tblCompany.cmbCompany;
On form2 the rowsource is:

Sometimes I like to review the code for a form event, or perhaps copy the
code from a form event.  To do so, I open the form in design mode, open the
property window for a command button, and open the code view for that
button.  I make NO changes or edits to anything.  Then I ...

I have an option control group with three selections; 1, 2 and 3.  I also
have three subforms stacked at the same location on a main form.
I wish to have my selection in the option control group control the hiding
or displaying of subforms.  That is, when I select option 1, ...

I have 3 tables.  
Table 1 - main table,
Table 2 - subform table and the one that gets cleared prior to next update  
Table 3 - table that permanently stores data from table 2 and is linked to

I have adapted my wizard code below to try and make sure
a record is not saved without a selection been made in
cboname this doesnt seem to work.  How do I change it to
work?

I have a form that allows users to transfer different text files from tables
based on input from the form using docmd.transfertext....  I need to allow
the user to specify the export location and filename using a savefiledialog
type of interface.  I think I can do this using .net ...

I want to enter a booking from 10am to 2pm, for say a camera (DC1), but the
camera may have already been booked from 9am to 3pm. I can create a query
that establishes the camera is already booked at 9am and who to and display
that result. But on closing and returning to the ...

When using docmd.outputTo to print a form's module to a text file you don't
get the properties for the form's controls. How do you get them?
I'am using the code
DoCmd.OutputTo acOutputModule, Me.Module, acFormatTXT, "C:\Junk.txt"