guess i didnt explain myself too clearly (apologies for this).
I want my database to hold the text value of "Jan-12" " Feb-12" etc instead of an actual date. I plan to pop in an Advanced Filter based on the text value for each month (I'll cross that bridge once i've got the basics sorted)
This is the code i used to copy data from my user form to the data base
I have an actual date entry already which can be entered manually (Like a specific invoice date) but my auto filter will then pull up all invoices within that month based upon the selection of the Period "Jan-12" etc
really hope this makes sense - as said, I'm a sledge with code! 'pinched' what code i have from various websites i've trawled through....