I have a form with a command button and when i click it, it opens another form to selct criteria for a report. what i'm trying to do is when i click button 1 to open the other form, i want to be able to disable certain controls depending on which command button was clicked on form 1. Is this possible?? Any help would be greatly appreciated.

Branden

Try putting some string like "condition_1" in the TAG property of the controls you want to have enabled when "condition 1" occurs (e.g. you click on a certain button in form 1 occurs). Use "condition_2" for some other type action.

Use the Open_Args parameter of the DoCmd.OpenForm to pass the string "condition_1" to the other form.

In form 1's OPEN event, read the Me.OpenArgs property. Then try something like this:

---------------------------------------------------
For Each ctl in Me.Controls

    If ctl.Tag = Me.OpenArgs then
        ctl.Enable = True
    Else
        ctl.Enable = False
    End If


Next ctl
--------------------------------------------------

You may have to "tweak" this but it has worked well
for me in the past.

Cheers!



--- Tom

I appreciate your reply but i actually figured it out. i used the following code

Private Sub cmdShiftReport_Click()
On Error GoTo Err_cmdShiftReport_Click

    Dim frmname As String
    frmname = "frmDetailReport"

        DoCmd.OpenForm frmname

            Forms.frmdetailreport.startdate.SetFocus
            Forms.frmdetailreport.EmployeeName.Enabled = False
            Forms.frmdetailreport.cmdStateDetail.Enabled = False

Exit_cmdShiftReport_Click:
    Exit Sub

Err_cmdShiftReport_Click:
    MsgBox Err.Description
    Resume Exit_cmdShiftReport_Click

End Sub

If this would help you out as it seems to be a little easier, feel free.

Branden