Null value on form problem <beginner> please help!

M

Mark Hanley

I have found similar problems to mine on this and other newsgroups but
I still haven't been able to solve my problem...

I have two tables 'Pupil' and 'SEN' which are related on a field
called 'UPN' (unique pupil number).

I have a form which is bound to a query that is drawn from both of
these tables and contains Pupil.UPN but not SEN.UPN aswell.

When I update the form I get the error 'The field SEN.UPN cannot
contain a Null value...'

Can anybody give me a hint as to what I need to do to put this right?
I'm tearing my hair out here!

Thanks.
Mark Hanley
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Null value on form problem <beginner> Please Help! 1
Combo Box returns null value when Child Link has no related record 0
Form filter combo box choices are Is Null/Is Not Null 3
Need help setting query criteria from a form 3
Replace "assign the null value" message 2
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Sort records in form with null values at end 8
Filter a list containing null values 3

Top