form to report

  • Thread starter Thread starter PN
  • Start date Start date
P

PN

I have a database tracking part mfg. The testing
technician would like to be able to select a category,
then have a list of parts in that category displayed from
which he could select the parts that were being sent out
for testing and if possible mark the parts as Out for
Testing? This list including category information would be
output to a report to be saved to Word or e-mailed. I'm
not a VBA programmer and am just taking over this database
as a newbie. I have a query containing all the information
but I'm not sure about the form output to report. Can
someone help me get started here? Thanks
 
Not sure exactly what you mean by "I have a query
containing all the information" but anyway...

If the form is working correctly and the technician can
mark the status of each part as OutForTesting, then you
already have the functionality you want. You just need to
create a report that includes the information that you
want and put a command button on the form that emails the
report to a recipient.
 
Back
Top