View Full Version : Cannot enter fields in Forms.


Ernie Lum
04-16-2001, 08:19 PM
Needed some help in this area?

I cannot input in the Student ID field on the form. It says Record not updatable?

:-)

llkhoutx
04-17-2001, 12:03 PM
This means the recordsource for the form is a probably a query with multiple linked tables. Access doesn't keep track of the source of the various fields.

When you want to update, do it via VBA code with criteria that identifies the particular record being updated. You should know which table is involved.

llkhoutx
04-17-2001, 12:04 PM
This means the recordsource for the form is a probably a query with multiple linked tables. Access doesn't keep track of the source of the various fields.

When you want to update, do it via VBA code with criteria that identifies the particular record being updated. You should know which table is involved.

Alternatively, use a query to update the required table with appropriate criteria.

Pat Hartman
04-17-2001, 06:21 PM
Just because a query includes multiple table joins does not make it not updateable.
Download the paper on the subject from the Microsoft download site for some possible problems:
http://support.microsoft.com/support/kb/articles/Q148/5/81.asp?LN=EN-US&SD=gn&FR=0&qry=harness&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC