Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem adding new record via subform

Status
Not open for further replies.

topgeek

MIS
Oct 28, 2001
59
GB
I've got a simple training database that has three tables:

tblCourse
tblAttend
tblEmployees

I have a main form which displays employee information and the subform displays the courses they have attended. Whenever I try an add a new record to the subform for any employee I get an error message:

"Field cannot be updated"

The subform properties are set to edit so I can't see why I can't add anew record?

I'd be grateful for any assistance!!

Best Regards
 
This could either be something to do with relationships, or with the fields thatyou have on the some form (ie if they come from more than one table)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top