CODEWITHSUNDEEP
formsms-accessmacros
Giacomo Brunetta
Giacomo Brunetta

Reputation: 1567

Microsoft Access Where Condition doesn't works in a subform

I built a form called: "clientlist": enter image description here

I put a macro with where condition on click:

="IDclient_logindata=" & [Maschere]![clientlist]![IDclient]

this means that when I click on an id client, access will open another form with the respective IDclient. For example if I click on IDclient 3: enter image description here

it open another form called "client_logindata" filter to IDclient_logindata 3. Then, I built a navigational form: enter image description here using clientlist as subform. But when I click a record, any record, it open every time the client_logindata form with IDclient_logindata form = 1, why it doesn' works in a subform? Design View of "Navigation Form":enter image description here

Upvotes: 0

Views: 1586

Answers (3)

Steve Lovell
Steve Lovell

Reputation: 2564

The OP has found a working solution which is much simpler than what follows. However, I was still interested to see if we could get something on the original model to work, and I'd guess that for users attempting to achieve the same thing using VBA rather than embedded macro's the following may still be useful.

The issue with the code in the original question is that the relevant form isn't open at the 'top level' but as a subform.

Form "normal" subforms, you'd refer to the control on the subform like this:

Forms!navform!clientlist.form!IDclient

Where navform is the name of the outer form. Or in the generalised case, like this:

Forms!Mainform!Subform1.Form!ControlName

However, the "Navigation Form" Wizard, when dragging subforms onto the Add New tab in Layout view doesn't name the subforms nicely. So I had to code it this way:

Forms![Navigation Form]!NavigationSubform.Form!ControlName

To my surprise this code continued to work when I added further forms within the Navigation Forms tabs and had controls named the same as one in question. I guess NavigationSubform automatically points to the tab with the current focus.

Upvotes: 0

Giacomo Brunetta
Giacomo Brunetta

Reputation: 1567

Solved in this way: ="IDclient_logindata=" & [IDclient]

Upvotes: 1

Parfait
Parfait

Reputation: 107652

When using a subform, references to controls need to be relative to the main form where the subform is treated as a child control.

Consider adjusting the conditional to the following structure. Do note this is the English version:

="IDclient_logindata=" & Forms!myMainForm!mySubform.Form!mySubformControl

Or specifically tailored to yours (be sure to get exact spelling of all objects):

="IDclient_logindata=" & Forms!NavigationForm!clientlist.Form!IDclient

Upvotes: 0

Related Questions