The title of your thread is the reason you didn't get any responses so far - "generating" t'aint useful, remember that in the future ("generating Access reports with VBA" would be more descriptive.)

I am not one for coding in VBA, but I will give the link to your thread to some good coders on here.