Required fields and Linked tables

[Tezdread]

Hi all,

I have split a database, then realised that I needed to change two fields in a form. Y/N field and Text field.

I went into the backed database changed the fields to be Required but in the front end it doesn't seem to work? I haven't tried re-linking them but should I need to?

thanks

 

[ScottGem]

what specifically isn't working?

 

[Tezdread]

what specifically isn't working?[/qoute]

The Required fields...

The fields are in a sub form, I can move off the fields without being prompted to enter data and I can also add new records?

 

[ScottGem]

Setup requirements on the form using Validation rules.

 

[Tezdread]

why isn't Required field working?
I'm not that familiar with validation rules...

One the text field it should store the persons name (whoever is entering the details) but this could be anything (john or malcome hayward) so how do I put validation in for random text entries?

How do I add validation to a Yes or No field?

 

[ScottGem]

I'm not sure why the required property isn't carrying over on a linked table. But with a Yes/No field I would simply set a default value. That will ensure that the field is not Null. As for Text fields, it depends on what validation you want. If you want to ensure the field is not left null just set a validation rule on the Control to Not Null. Look up Validation rules in Access Help for more details.

 

[Tezdread]

ok that Scott I'll give those a go
thanks for your help

 

[ScottGem]

glad to assist