create List Button

D

Denver

Hi,

I have a form with a subform, I wnat to create a button that
would export after making a filter in my subform with only 6 rows.

I want only this to appear in the spreadsheet,

Drawing No. Sheet No. Site Name Index Rev Description

i don't want to export all the 30 rows in my databse, can this be possible?
How would i start my code?

Thanks for any help I appreciate
 
P

PieterLinden via AccessMonster.com

Denver said:
Hi,

I have a form with a subform, I wnat to create a button that
would export after making a filter in my subform with only 6 rows.

I want only this to appear in the spreadsheet,

Drawing No. Sheet No. Site Name Index Rev Description

i don't want to export all the 30 rows in my databse, can this be possible?
How would i start my code?

Thanks for any help I appreciate
Click to expand...

Did you try creating a top values query based on the recordsource
(query/table) that your subform is based on, and filtering it by the foreign
key? Then you should be able to output it just fine.
 
Top