Newbie Questions

Re: Complex form...

Ben Brown — Wed, 04 Jun 2008 11:01:47 GMT

That's brilliant. Thanks for your help!

Ben

Re: Complex form...

barmatt80 — Wed, 04 Jun 2008 01:31:38 GMT

sorry i missed a part, though of it on my way home from work. In your conditions, add if your text box is blank AND eshop is equal to true.

Re: Complex form...

barmatt80 — Tue, 03 Jun 2008 20:56:44 GMT

Your e-shop check box should have a data type of boolean (True/False). Set the default value to false. Lets say that box is called eShop.

Then on each text box, right click each one and under properties click data valadation. Then once that brings up a screen, click Add.

Within that screen your if statement shoudl be: eShop is equal to TRUE(select this don't type) then you can type a message in. that will require that field to be filled in. If you need somethign specific to be in that field or formatted a particular way, create another validation rule.

Repeat for second text field.

http://cid-7a987d5d6da9cbd6.skydrive.live.com/self.aspx/Public/eshop.JPG

Re: Complex form...

Ben Brown — Tue, 03 Jun 2008 16:02:33 GMT

Well I though I'd got it...! But it seems not.

Just to be clear, when the user ticks the e-Shop box, the two fields below should turn to be mandatory...

Thanks for any help whatsoever :)

Re: Complex form...

Ben Brown — Mon, 02 Jun 2008 08:46:32 GMT

Thanks for that - sorry for not replying sooner, have been away.

Will have a go and pester you when I get stuck.

Ben

Re: Complex form...

Clay Fox — Sat, 24 May 2008 04:23:38 GMT

Hey Ben.

You can put conditions on validations.

So you can set requirements based on a field value.

Complex form...

Ben Brown — Fri, 23 May 2008 14:14:11 GMT

We are designing a form for managers to fill in with new user details, when someone new starts work.

Part of the form is about what access to software a new user will require. One of the software packages requires an external supplier to set up the new user, so if a manger ticks a box on the form, how do I then make another part of the form switch to make the fields mandatory?

Thanks for any help at all.

Ben