the field cannot contain a null value because the required propert

[Guest]

I need help!!! I created a form that is based on a multi-table query (2
tables). Everytime I try to save a new record, I get "The field
'tblCommRequestForm.CRFNo' cannot contain a Null value because the required
property for this field is set to True. Enter a value in this field."

The problem is that the field it is referring to is not in the form.
Rather, I have the field 'tblPayments.CRFNo' in this form. And just so
happens, this field is a combo box looking up from the
tblCommRequestForm.CRFNo.

Also, when I try to add a new record, I get 'Can't go to the specified
record.'

How can I make these errors go away???

LaVerna

 

[Guest]

Sounds like your combo box is bound to a field in the form's recordset. You
need to make in a unbound control.

 

[guido via AccessMonster.com]

It sounds like you need to set up your table relationships. First set the
primary key field(s) for each table, then go to Tools - Relationships to set
of the table relationships.

 

[Guest]

How do I make it an unbound control without getting rid of my combo box?

 

[John Vinson]

How do I make it an unbound control without getting rid of my combo box?

Set its Control Source property to blank.

John W. Vinson[MVP]