Need help with Form coding

  • Thread starter Thread starter AlbertaRose
  • Start date Start date
A

AlbertaRose

I have a form with multiple fields to select from. Not all fields will be
populated for each report request. What is the coding I would use to have
Access go through the form, select the information requested and populate it
to my report?
 
A report is normally populated from either a table or a query. I think you
need to be clearer on what you want.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
Yes I know that a report is populated from a table or a query. I guess what
I'm asking is more of a query coding question.
 
My form has the following fields.

Contract Number (combo box)
Product Class From (combo box)
Product Class To (combo box)
Description (text box)
Diameter lowest (text box)
Diameter highest (text box)
Beginning Date Range (text box)
End Date Range (text box)
Customer (combo box)
Owner (combo box)
City/Location (combo box)
Province (combo box)
Country (combo box)

Any combination can be requested, some are combo boxes, others are text
boxes. For the Description box, I have made a wild card query to pull
information by specifics, e.g. spheres.

I want to write a query that will look at each of the fields in this form
and determine if there is a value indicated. If so, check the other boxes to
see if there are more parameters and include them in the search. I think I
need an If statement, but have not had much experience yet in this.

Thanks for your patience with a newby...Laurie
 
Back
Top