Can't add a record because a record is required in the subform

  • Thread starter Thread starter Jo Gjessing
  • Start date Start date
J

Jo Gjessing

Hi Folks,

In a database of mine I have a form with a few text boxes (first name, last
name ...) and some subforms for additional information. When
I try and register a new person and have typed in what is required in the
form, I move to the first subform. Then Access says that it can't add a new
record (in the form, as I understand it) because a record is required in the
first subform. Have you any idea what this is and how I fix it? If you have
please
let me know. Thank you very much in advance.

Jo
 
Hi Folks,

In a database of mine I have a form with a few text boxes (first name, last
name ...) and some subforms for additional information. When
I try and register a new person and have typed in what is required in the
form, I move to the first subform. Then Access says that it can't add a new
record (in the form, as I understand it) because a record is required in the
first subform. Have you any idea what this is and how I fix it? If you have
please
let me know. Thank you very much in advance.

Jo
Click to expand...

I swear they've changed the way this works - I've had the same issue
since Access 2003. The easiest fix is to have the record saved before
getting to the subform - use the subform enter event to commit the
record (Me.Dirty=False, which is so true on so many levels).

Hope this helps,
James
 
Hi Folks,

In a database of mine I have a form with a few text boxes (first name, last
name ...) and some subforms for additional information. When
I try and register a new person and have typed in what is required in the
form, I move to the first subform. Then Access says that it can't add a new
record (in the form, as I understand it) because a record is required in the
first subform. Have you any idea what this is and how I fix it? If you have
please
let me know. Thank you very much in advance.

Jo
Click to expand...

Start with the data. Forms are *just windows* - if you're starting your
database with the Forms you're on the wrong track. Pour the foundation for
your house before you start installing the windowframes!

What are your Tables? How are they related? What's the Recordsource for the
form, and for the subforms?

John W. Vinson [MVP]
 
Back
Top