I'd like to know if it's possible to use the autonumber function to create an automatically generated number in the format mmddyyyy-000? I've tried a varying number of ways, but none of them work so far. Will this require code as opposed to just using the autonumber formatting?

Use the autonumber field to keep track of records and hide it from the user.

Then create a date field

Then create your own code to populate the number field, then join them in a query, or on your form and reports.

I have seen this posted in this forum but don't have time to go find it right now.

HTH

mmcdonal