check box selected and automatically update another field with specific data

[neill_long]

Hello



I have a form that when a check box is selected, the date field will automatically populate with todays date. I also want it to populate another field but unsure how to do it and need some advice.

The field I want to populate is Finance Account Code. The data in it should be ID Number (which in this example is 123456) this field is called Borrower#. There should be a D at the start of the number when in the finance account code. So in this example the field would say D123456.



on the check box, I have embedded a macro:



Do I need to set something up on this macro or do you have a better suggestion?

thanks
Alistair

[pbaldy]

I don't use macros, but you should be able to add another SetProperty to set the value of the account textbox. You realize you're including time in your date value? The Date() function will input just the date, if that's more appropriate.

[pbaldy]

By the way, the second example here would be the VBA method to do what you're doing:

http://www.baldyweb.com/ConditionalVisibility.htm

[neill_long]

I hadn't realised about the date but have changed it now.

I have added the VBA and it is working perfectly. thanks very much for your help

[pbaldy]

Happy to help and welcome to the site by the way!