making fields updatable in forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to Access and VB and I have been struggling with a form that
contains repeating lines in a subform. There are 2 fields in that form that
should be updatable, but it just won't allow me to. I have set the allowedits
property for the subform to true and set the enable property of those two
fields to true.
The RecordSource for the subform is a query which joins tables and queries.

Does anybody have any idea on why those fields cannot be updated in the form?

Thanks for any help or leads!!!
 
Sounds like your recordsource is not updatable. Joining multiple tables and
queries can create that problem.
 
The RecordSource for your table must be updateable. To test this, open the
recordsource query and see if the NewRecord line appears at the bottom and
if the asterisk button appears on the navigation bar. If they do not, it is
not updateable. To find more information on what makes a query updateable,
go to Help and type: "when can I update data from a query" in the Answer
Wizard box. It will bring up a screen that explains under what conditions a
query is updateable.

Rarely do I ever have forms or subforms bound to queries joining multiple
tables. There is probably a better way to do it.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Thanks for your help.
I simplified my query to confine it to just one table. I can now update
fields when the query is brought up. However, when I used that same query
for my form's record source, the fields are still not updatable.
 
To save your self use a view (named query in access).

Only expose the primary key.

1. Test by basing your form on the primary table and linking to the exposed
primary key of the view using an IN() parameter in the where clause.

2. If this is ok you can test by linking to the exposed primary key in the
normal way (inner join).

If this reply is too complex to follow you will have to post your queries.

Regards John
 
Back
Top