Creating a Form-Based Parameter Query (1 Viewer)

[FilasLam]

I've been trying to create a form-based parameter query using videos on youtube. After several tries, while coping the video correctly, it still won't work. In the video's when done making the query, it works like it's supposed to. But when I run the query, it doesn't show any data. Does anyone know how to help me? Thanks in advance.

Some of the video's I used for reference:

 

[arnelgp]

you upload the db you are working right now.
maybe something to do with the correct "syntax".

all your videos are correct.

 

[FilasLam]

you upload the db you are working right now.
maybe something to do with the correct "syntax".

all your videos are correct.

 

[arnelgp]

what version you may have?
anyway, on your demo, form "Formulier ophalen test 47".
notice in design view of your combobox "test 46", the Bound Column = 1, meaning
the 1st Column from your Row Source (which is [Overzicht].[Id]) (from "Select [Overzicht].[Id], ...").
on your query "Query1 test 47", you set the Criteria to ID (since the combo is saving the ID).
see the form and the Query.

 

[FilasLam]

I finally understand what went wrong the whole time. Thank you! It's Access 365 (version 2206) btw.

 

[arnelgp]

t's Access 365 (version 2206) btw.

i asked because i have 2021 and if you have lower version and i make correction you might not be able to open the db.

 

[Pat Hartman]

.accdb's are compatible back to 2007 provided you haven't used any specific feature that wasn't available in an earlier version.