Duplicate Records Function

[dvannoy]

I Have a form with a button that allows the users to duplicate there records...

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70
Me![sampleno] = [sampleno] + 1
DoCmd.GoToRecord , , acLast


I have two fields that are date format. when i put a input mask on those two fields, they will not get copied to the next record. WHY???????

If I take the input mask off, it works fine.


Can anyone help with this?

Thanks

DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[DougP]

The only thing Acces will accept in a date field is this

mm/dd/yy

it will not insert a date any other way, period.
it does like dd/mm/yy or yy/mm/dd
or whatever other format you have

you may be able to do this

=format(yourdate, "mm/dd/yy&quot and put that in a separate hidden textbox and save it instead of the format you are using. so you end up with two boxes (one hidden) the one that you actually save into Access.

DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive