Command button error

[AndyRob1973]

Hello,



I have also posted this in Command button error | Access World Forums (access-programmers.co.uk)

(I've attached the database that I'm talking about below)

I have added a command button to the form ‘frm_PatientPlan’ called ‘Disable/Enable Invoice Code’, which works on a field called ‘Invoice Code’ that is on its subform ‘frm_PatientSchAll_subform’. It seems to work ok when I open up ‘frm_PatientPlan’ and click the button.



However, in practice the user will start with the form ‘frm_PatientList’, click on the Patient’s ID which opens up the ‘frm_PatientPlan’ for that patient. But when the ‘Disable/Enable Invoice Code’ is clicked I get the error.






Could anyone help please?

Thankyou.Option2_10 - Master.zip

[CJ_London]

What is the line of code creating the error? Click debug and it will be highlighted

[AndyRob1973]

Hi there,

It is :

If Forms(frm_PatientPlan).frm_PatientSchAll_subform.F orm.InvoiceCode.Enabled Then



Thank you!

[Welshgasman]

Just a quick Google shows the bang should be used, not the dot?
https://docs.microsoft.com/en-us/office/vba/api/access.form

! instead of .

Seems to be confirmed on another search. https://www.access-programmers.co.uk...b-form.318493/

[moke123]

You need quotes around the form name.

Forms("frm_PatientPlan").whatever

[moke123]

This works

    If Me.frm_PatientSchAll_subform.Form.invoicecode.Enabled = True Then
        Me.frm_PatientSchAll_subform.Form.invoicecode.Enabled = False
    Else
        Me.frm_PatientSchAll_subform.Form.invoicecode.Enabled = True
    End If

[Micron]

Why have the Else? Basically if it's true, make it false. No need to make it true when it already is. Or am I missing something?

[Minty]

Most of these answers and others on the other forum https://www.access-programmers.co.uk...-error.319128/

[Micron]

I misinterpreted the intent, so yeah, I missed the mark. That often happens when I post before coffee.

[AndyRob1973]

Thankyou Minty - just checking that it's ok to do this as I put a link on the first post.

Most of these answers and others on the other forum https://www.access-programmers.co.uk...-error.319128/

[AndyRob1973]

Thankyou all,

I have learnt a lot from all your replies.