Open Form Macro

[Harry Taylor]

I have a customer form [Heatersmaster]

In this form is a button to open [Phonebook]

[Phonebook] has a subform [PBSubform]
This shows contacts, some with account numbers, some without.

Where there is an account number I want to double click so it opens Heatersmaster on that account.


In [PBSubform] On Dbl Click I have a macro;

When I double click I get;

Where am I going wrong?

 

[Gasman]

I do not use Access macros.
In VBA you would need the Forms!FormName!SubFormControlName.Form.ControlName

Forms: Refer to Form and Subform properties and controls

 

[Harry Taylor]

Thanks Gasman
I'm early days with VBA. I get what you mean, but could you spell it out a bit please, sorry.

 

[LarryE]

I have a customer form [Heatersmaster]

In this form is a button to open [Phonebook]

[Phonebook] has a subform [PBSubform]
This shows contacts, some with account numbers, some without.

Where there is an account number I want to double click so it opens Heatersmaster on that account.


In [PBSubform] On Dbl Click I have a macro;

View attachment 115944
When I double click I get;

View attachment 115945

Where am I going wrong?

I don't use macros, but it appears to me that you are attempting to open the Heatersmaster form based upon some criteria from a different form (PBSubForm). If PBSubform is a sub-form of Heatersmaster form, then the Where Condition should be:

=[ACCOUNT]=Forms![Heatersmaster]![PBSubform]![ACCOUNT]

 

[Harry Taylor]

This doesnt work, but what about something like this;

DoCmd.OpenForm "Heatersmaster", _
WhereCondition:="Account=" & Me.Account

 

[Gasman]

Cannot make it any easier than that TBH?

Try Forms!PhoneBook!PBSubform!Form!Account

I am assuming that the subformcontrol name is the same as the subformname, which tens to be the case if you drag and dro

 

[LarryE]

This doesnt work, but what about something like this;

DoCmd.OpenForm "Heatersmaster", _
WhereCondition:="Account=" & Me.Account

Also, make sure the [ACCOUNT] field is included in the Heatersmaster form Record Source.

 

[Gasman]

This doesnt work, but what about something like this;

DoCmd.OpenForm "Heatersmaster", _
WhereCondition:="Account=" & Me.Account

Not even sure you can use Me. in macros?
Try googling 'Open form access macro'
Your issue is the control is on the subform and you are not addressing it correctly.