DoCmd.setProperty

[michi]

Hello all
I am a newcomer to VBA. I am trying to open a form "frmAuftragUebersicht" from the form "frmStart" via a command button. In the new form the field "cboKunde" should get inactive. It still does not work after hours. Please help me.


Private Sub cmdAuftragAusgefuehrt_Click()
'------------------------
'Das Formular frmAuftragUebersicht öffnen
'und den Fokus in das Feld cboAuftragsnummerSuchen setzen
'das Feld "cboKunde" soll inaktiviert werden
'------------------------
DoCmd.OpenForm "frmAuftragUebersicht", acNormal
DoCmd.GoToControl "cboAuftragsnummerSuchen"
DoCmd.SetProperty "cboKunde", acPropertyEnabled, "0"




End Sub

[pbaldy]

Try

Forms!frmAuftragUebersicht.cboKunde.Enabled = False

[pbaldy]

To clarify, your code becomes:

DoCmd.OpenForm "frmAuftragUebersicht", acNormal
Forms!frmAuftragUebersicht.cboKunde.Enabled = False

[Micron]

You cannot use that syntax in the code of the same form that you're using to open form B. You must use

Forms!myFormNameHere.theControlNameHere.Enabled = false

However, if you're going to do this regardless, as you have shown, why not just set that property in form design and be done with it? Are you setting focus (going to) some control because cboKunde has the focus when you open the form? If so, could just either remove it from the tab order or set the tab index to something other than zero.

[michi]

Thank you very much for the tips. I use the frmAuftragUebersicht form in three different phases. 1. to enter a new order. 2. to complete the work on the order. And thirdly, when the customer picks up the order. So I want to make fields inactive that should no longer be changed.

The code 'Forms!frmAuftragUebersicht.cboKunde.Enabled = False' does work.

[davegri]

You can use the OpenForm OpenArgs to pass "instructions" when opening one form from another. This is handy when the target form is opened from several other forms and the target needs to know how it is expected to react. The target uses the Form_Open event to analyze the OpenArgs value to take appropriate actions, like disabling a control.