date Format in Combobox - format changes when data is transferred to database??

[sgtbash999]

Hi all,

I hope this is a simple fix but i've tried all ways and my database is having none of it (admittedlly i'm a complete ploker when it comes to code

I've got a combobox on a user entry form and i've loaded it with Months in the following format "Jan-12" for example. trouble is, when this data is transferred to the database it's being displayed as "12-Jan" and i cant work out how to format it correctly?

This is an extract of the code for the form i have

Please Login or Register  to view this content.

Hope someone can help. Cheers

Glen

[Firefly2012]

And what code are you using to transfer the value to your database? What value do you want your database to hold? A text value such as "Jan-12" or an actual Excel date such as 01-Jan-2012?

[sgtbash999]

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

Please Login or Register  to view this content.

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....

[Firefly2012]

I think all you need to do is make sure the cell you transfer the data to is formatted as text:

Please Login or Register  to view this content.

[sgtbash999]

YOU ARE A STAR!!!!!!!!!

Thanks so much for that - works a treat!

now on with the advanced filter...... got a feeling i'm gonna be spending alot of time searching hrough this forum ha