Bound query field using an autonum field from bound form

J

JimC

I have a bound form that when data entry is complete, generates a Work Order
Number using autonum. I created a query which is bound to that form and the
autonum field as the control field. When the user is finished entering their
data they hit a button which runs a SendObject macro which sends a report
using the bound Query to a specific email address. The report is always
empty. If I run the same steps without having the query bound and instead
prompting for the Work Order Number it runs correctly.
My question is can I use an autonum field as the control for the query and
if so what do I need to do to get data passed from the form to the query?
Thanks for any help you can give me.
 
L

Larry Daugherty

Hi Jim,

If by "macro" you mean an Access macro then you're shooting yourself in the
foot when it comes to troubleshooting. See if you can convert that macro to
VBA code and then use the debugger to see what value you are passing for
that autonumber field.

HTH
 
Top