Hi,
i'm a total beginner with access and i wonder how to get a Parameter from a form into a query ...
more precise:
I have a form with a subform and a table. However I want to enter a number in the Form and then the subform shall display all entries from the table with that number as a specific field. So to speak i want to apply a filter.
Can i do that somehow without using VBA ? And without entering the number in that tiny dialog window that pops up when i use "[ ... ]" brackets in my query ?
This is may query so far .... and it is the datasrc for my subform ...
Code:
SELECT tbl_autos.ID, tbl_autos.Typ, tbl_autos.Alter, tbl_autos.BesitzerID
FROM tbl_autos
WHERE tbl_autos.GaragenID = <Param>;
i want to replace <Param> with the content of my form.
Thanks and greets so far from
fluppe