Query from a list in the Form

[SoulGame]

Hello, I'm in Micrososft Access 2016 and I have a list on the form.
I want to filter the field in the list by ID. The filter ID is the form, so I want to access one of the variables inside the form in the SQL statement.

I have this query now:

SELECT t_parents.CodiParent, t_parents.CodiFamiliaParent, t_parents.CodiTipusFamiliaParten, t_parents.CodiMotiuParent, t_parents.Cognom1, t_parents.Cognom2, t_parents.Nom, t_parents.[nif/nie], t_parents.Origen_Nivell_Renda, t_parents.Sol·licitant, t_parents.Altres_Rendiments
FROM t_parents
WHERE (((t_parents.CodiFamiliaParent)=1));

they filter for a ID static ( ID = 1 )




But I want to filter by a form ID:


Thanks !!

[andy49]

= me.codialu


Sent from my iPhone using Tapatalk

[SoulGame]

= me.codialu


Sent from my iPhone using Tapatalk

With this query ask me for the ID when opening the form:

[andy49]

Can you use the query builder (design)? It will allow you to put the textbox in as part of the where clause and get the correct syntax


Sent from my iPhone using Tapatalk

[SoulGame]

Can you use the query builder (design)? It will allow you to put the textbox in as part of the where clause and get the correct syntax


Sent from my iPhone using Tapatalk

How can I do it? I'll add the list and do not ask me if I want to link it to ID

[andy49]

this works fine for me


WHERE (((t_parents.CodiFamiliaParent)=[Forms]![Formname]![Textboxname]));

[SoulGame]

this works fine for me


WHERE (((t_parents.CodiFamiliaParent)=[Forms]![Formname]![Textboxname]));

I do not get it. I am proving in many ways and it does not work for me. I tell you the names of the form:


Name form: AddAlumneDades (serio1)
List Name: Lista73
Name field of the table: CodiFamilia


I have interacted with:

WHERE (((t_parents.CodiFamiliaParent)= me.For[AddAlumneDades(serio1)]
[Lista73]![CodiFamilia]));

Is correct?

Thanks

[aytee111]

WHERE (((t_parents.CodiFamiliaParent)= Forms![AddAlumneDades (serio1)]!CodiFamilia));

Then in the AfterUpdate event of CodiFamilia, requery the listbox:
Me!Lista73.Requery