How to change Default Value on Form

L

larochy

This question relates to the default value for a field on a subform. I have
an unbound box that allows the user to type in a new default rate and in the
After Update event it changes the default value for the rate field. This
works fine until the user closes the form and it reverts back to the old
default value for the Rate field. I tried saving the form using the OnClose
event but that didn't work either. What do I need to do to make the new
default value for the rate field stick when the form is closed?
 
L

larochy

Sorry but after looking at it further, the problem seems to be saving the
subform. Is it possible to save the subform when closing the main form? I
can't get it to work by just doing:

DoCmd.Save acForm, "[Forms]![frmProjects]![frmHours].[Form]"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
Dynamic Naming of Form Button 3
Default Value on Form Help 1
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Pop-Up Form 9
Default value in date filed on form 10
How to set tabs in work document 0
Combo Box Selection is Blank 1

Top