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?
:-)
I cannot input in the Student ID field on the form. It says Record not updatable?
:-)
|
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 |