Pasting values from one field to ttwo others automaticlly

  • Thread starter Thread starter Thernan102
  • Start date Start date
T

Thernan102

I have a form for entering products with the fields sku,
details, and image. I need the value of Sku after being
updated to be duplicated to details and image. In details
I also need the extension .rtf added at the end and for
image .tif.
 
Dont use the plus symbol (+) as it adds numeric values and you'll get an
invalid data type, type mismatch or other error / unexpected values.

Use the following

Me!Details = sku & ".rtf"
Me!Image = sku & ".tif"

Sean
 
Thanks! I will remember for that in the future. I did try
the code out ahead of time (as I always do) and it did work
out fine for the couple of examples I tried.

Mike


: Dont use the plus symbol (+) as it adds numeric values
: and you'll get an invalid data type, type mismatch or
: other error / unexpected values.
:
: Use the following
:
: Me!Details = sku & ".rtf"
: Me!Image = sku & ".tif"
:
: Sean
:
: ::: I have a form for entering products with the fields sku,
::: details, and image. I need the value of Sku after being
::: updated to be duplicated to details and image. In
::: details
::: I also need the extension .rtf added at the end and for
::: image .tif.
::
:: I would think this should work:
::
:: Private Sub Sku_AfterUpdate()
::
:: Details = Sku + ".rtf"
:: Image = Sku + ".tif"
::
:: End Sub
::
::
::
::
:: ---
:: Outgoing mail is certified Virus Free.
:: Checked by AVG anti-virus system
:: (http://www.grisoft.com).
:: Version: 6.0.507 / Virus Database: 304 - Release Date:
:: 8/4/2003
 
Thanks Guys!
-----Original Message-----
Dont use the plus symbol (+) as it adds numeric values and you'll get an
invalid data type, type mismatch or other error / unexpected values.

Use the following

Me!Details = sku & ".rtf"
Me!Image = sku & ".tif"

Sean




.
Click to expand...
 
In the after update event of the sku, just put:

me!Details = me!sku & ".rtf"
me!Image = me!sku & ".tif"
 
Back
Top