Writing codes

  • Thread starter Thread starter Baffled
  • Start date Start date
B

Baffled

My report lists site visits between 2 dates (i specify
dates on a form) which shows all contact within said
dates, however, i would like a report based on only one
Company, i added a combo box but am stuck as how the
report will only pick up 1 CompanyName from combo box and
preview that report.

Any suggestions guys.
My form is called sitevisits
and combo box is called cboCompanyName

Thanx
 
One approach would be to have the query underlying your report use the
form's combo box contents. The expression in the query's criterion row for
that field would look something like (your syntax may vary):

=Forms![YourFormName]![YourComboBoxName]
 
Back
Top