Keep Value

  • Thread starter Thread starter Robin
  • Start date Start date
R

Robin

Brain Freeze....

I have a form and I want to take the date entered and auto
populate when adding the next record.

Help....
 
Brain Freeze....

I have a form and I want to take the date entered and auto
populate when adding the next record.

Help....
Click to expand...

Set each desired control's DefaultValue property in the Form's
AfterUpdate event:

Me!txtX.DefaultValue = """" & Me!txtX & """"

The quotes are needed because (regardless of the field's datatype) the
Default Value must be a string.
 
THANK YOU!!! I can stop pulling my hair out!
-----Original Message-----


Set each desired control's DefaultValue property in the Form's
AfterUpdate event:

Me!txtX.DefaultValue = """" & Me!txtX & """"

The quotes are needed because (regardless of the field's datatype) the
Default Value must be a string.


.
Click to expand...
 
Works great on date...what if it's a combo box??

-----Original Message-----


Set each desired control's DefaultValue property in the Form's
AfterUpdate event:

Me!txtX.DefaultValue = """" & Me!txtX & """"

The quotes are needed because (regardless of the field's datatype) the
Default Value must be a string.


.
Click to expand...
 
Works great on date...what if it's a combo box??
Click to expand...

A combo box is a display tool. It is NOT a data type. If you have used
the <yuck, PTOOIE!> Lookup Wizard in your table, then the table
actually contains a numeric ID which the stupid wizard conceals from
your view. If you want to set its default property, you need to set it
to the numeric ID. This should be doable using the Control Source of
the combo as the default property.
 
Back
Top