2. ASPRunnerPro General questions
  3. Update two fields
This topic is locked

Update two fields

 		5/14/2007 6:40:29 AM
ASPRunnerPro General questions
H
 hoppo1 author

Hello,
I'm just trialling asprunner and would like to know ( and how ) if the following is possible on an access database -
User adds data to a field called "Company" ie Virgin Media once the form is saved Virgin Media is the written to another hidden field in the same database called "SearchCompany" as capitals with no spaces so would be VIRGINMEDIA. In the database there are then two fields -
Company SearchCompany

Virgin Media VIRGINMEDIA
Is this possible? I have tried a few things and so far not had much luck nor has searching returned anything to work on.
Thanks
J
 		Jane 5/14/2007

Hi,
you can do it using Before record added event on the Events tab.

Here is a sample code:

dict("SearchCompany") = Ucase(replace(dict("Company")," ",""))
H
 		hoppo1 author 5/14/2007

Brilliant does exactly what i wanted <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=17876&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />
Thanks for your help and quick response.