Required fields

[chuckster]

How can I make a field "required" dependant on another field having a value in it.

tia.

 

[Jack Cowley]

Sydneysider-

At some point in your form use code to check to see if your 'required' field has been bypassed (is null) and the other field has the correct value. If so then pop up a MsgBox stating that the field is required and send them back to that field.... If you need more specific 'code' then email me directly, if you like.

HTH,
Jack

[This message has been edited by Jack Cowley (edited 10-19-2000).]

 

[chuckster]

Thanks for the advice that's what i will do if this other idea doesn't work but I want to make the form appear less congested if the other fields aren't necessary.

I have a whole groups of agents who have sub agents under them. Many have only one or two but others have up to ten. I was hopeing the form could leave out the fields that aren't needed. Any ideas?

 

[Jack Cowley]

Sidneysider -

I am not completely clear on how you want to display the original 'group' of agents, but if they are all displayed on a single form then you might consider puting subforms under each agent with their agents listed there. Limit the size of the subforms to show two agents. For those agents with more agents under them you would need to scroll through the subform to see all of their agents.

You could also make your form two pages long, use a Page Break and move between pages with button clicks. Do not know what else to suggest at the moment....

HTH,
Jack

[This message has been edited by Jack Cowley (edited 10-21-2000).]

 

[stoffer]

Could you please post an example of this code? I have a database with personal address on one side and business on the other. For report & query purposes I want to make the "COUNTY" field a required field but only on either the personal or business side. EG, if a business address is filled in the COUNTY field then I don't need the COUNTY field of the personal address side of the form to be filled in and vice versa.