on get focus code updates default value field issue

R

Ran BD

Hi guys' it's me again.

imp using this statement:
Me.Mis_Han.DefaultValue = DMax("[Mis_Han]", "Sapak_Tbl") + 1 to get an
updated value of the field Mis_han.
this statement - entered on the on get focus property, stores a number in
the default value property.
the next time I'm opening the form the previous value is being displayed.
 
S

Steve Schapel

Ran,

Setting form or control properties via VBA code only applies to the
current session.

- Steve Schapel, Microsoft Access MVP
 
R

Ran BD

I know that, but if you'll read threw the msg I wrote you'll see that access
behaving strange in this current incident.
thanks
Steve Schapel said:
Ran,

Setting form or control properties via VBA code only applies to the
current session.

- Steve Schapel, Microsoft Access MVP


Hi guys' it's me again.

imp using this statement:
Me.Mis_Han.DefaultValue = DMax("[Mis_Han]", "Sapak_Tbl") + 1 to get an
updated value of the field Mis_han.
this statement - entered on the on get focus property, stores a number in
the default value property.
the next time I'm opening the form the previous value is being displayed.
Click to expand...
Click to expand...
 

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

Retrieving value from a table 4
Default Value for a Text box field 1
Default Value or Control Source? 4
table doesn't update until after I press the escape key 1
After Update and Set Focus Issue 2
Checking for, then listing Null/empty fields in a message box 0
Limit to list and default for combobox 3
Create subform default values based on value set in main form 14

Top