I have combo box with 2 options: Standing or Special
I have a problem to put that combo box contant in an IF statment.
what is the right way to write:
If combobox = Special then......

Ok what I want to do is have on exit of SubForm2 (frmCondition) to
RecordsetClone SubForm1 (frmAddresses). PROBLEM!! Everytime I run the
code it stops on my Main Form (frmInspectBy) declaration.  It says it
can't find the Main Form RunTime Error 2465. I've checked to make sure

Hi,  I hope you can help me.  I have a screen with several buttons on the
button that I enable and disable based on user selections/actions.
I will call this main form:  Main_Form.
One button runs a Module that imports a bunch of data and does a lot of

I have a value in my table called Req_No. To get the next request number
I use =Max([Req_No] +1). How can I eliminate the Req_No from showing on
the form and have the max request show instead?
I don't want to have to type in the request each time. Is this a

A form contain a datagrid with sorted data.
Is there a simple way to color only the lines with duplicate customer number
Like with nthe conditional formating tools
(Can we refer to a preceeding line?)

I have built a form with multiple subforms that the user can change which
subform a record appears. Using the following code for  each subform,in the
afterUpdate event of the combo box ,the user can both enter a new record,
edit and existing record or change the subform the ...

I apologize in advance for the longwindedness of this post, but I can't for
the life of me figure out the problem so I'll err on the side of providing
too much info.  Also, this might be nearly impossible to diagnose this way,
but if anything strikes you as strange or wrong, please ...

I have a form with a datasheet subform.  I want to enter a date in an
unbound control in the main form and execute a private sub to find the
date in the subform.  The name of the unbound control is "Jake".  The
name of the subform is "Arleen".  The name of the date field in the

I'm aware that I can undo a change to all fields in a record in a
subform by using the following syntax:
Forms![frmLookUpData]![subfrmComponentName].[Form].Undo
where frmLookUpData is my form and subfrmComponentName is my subform.

Can anyone help me, i needed to programme a form to open a report. For
instance, if type in a existing item, then it should ask weather i want to
edit the existing record or not and then if i say no, it should ask weather I
want to view the report on the existing Record.

I have a database I've been working with at work and keep getting an error
message reading:
Run-time error '2455
You entered an expression that has an invalid reference to the property

Is there a way to link a textbox control to a Autonumber field(ProcessID) in
a table.
Once I open the form I would like for the text Field to be automatically
populated with the corresponding data.   Or should I use a Label Control

I've got a form called frmCustomers.  Inside this form is subform
(sfrmCustProdRates).  In sfrmCustProdRates I have a command button that opens
frmTransactions.  The intent is to associate products to customers and to
enter transaction details for those product/customer ...

I am having an interesting problem.
here is the SQL statement i am using.
SELECT [Work Order].[Tool #], [Work Order].[Est Comp Date], [Work
Order].Reason, [Work Order].Status

I have a text field that the client has specified will increment
hexidecimally.  So, 1, 2, 3, 4, 5, 6, 7, 8, 9, A, B, C, etc.  To do this, I
have the following code in VBA
Private Sub Form_Current()