I'm trying to keep a date in a subform. Once the user enters a date and the procedure done on that date, he clicks on Add Record button and all the fields in the sub form are blanked out.

I need the date to stay the same so the user doesn't have to reenter it for each each procedure.

I tried Allen Browne's code and I can't make it work??

http://allenbrowne.com/ser-24.html

I'd be grateful for any suggestions.

As I understand you want to fix the date. If this is the problem then if you take the system date then all you need to set the control source property of that text box to =Date() then the date will be fixed always.

I hope this helps

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.