Passing values into a query from a form.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying figure out a way to make a form that you can pass values into a report query. The two fields are simple...a date and a 1 or a 2 for the shift. Reason I want to do it from a form is because I want to put in a calendar object that the user can select the date from so its the right format for the query. How the heck do I do this? I am relatively new to the Access/VBA world. So hopefully you can give me the "for dummies" answer.
 
Create fields on the form for the user to enter the
values and save the form but leave it open. Then open
the report query, locate the column in the query that you
want to pass a value to and go to the intersection with
the "Criteria" row, right click the mouse and
select "Build" from the menu. In the builder select
Forms, Loaded Forms from the left hand column, select the
form and field you want along with the parameters in the
other columns.

-----Original Message-----
I am trying figure out a way to make a form that you can
Click to expand...
pass values into a report query. The two fields are
simple...a date and a 1 or a 2 for the shift. Reason I
want to do it from a form is because I want to put in a
calendar object that the user can select the date from so
its the right format for the query. How the heck do I do
this? I am relatively new to the Access/VBA world. So
hopefully you can give me the "for dummies" answer.
 
Back
Top