annoying (but probably simple)

[Richio]

Friday afternoon blues

Two forms based on one table (one through a query to filter it down)

The idea was that the second form only showed limited info from the table.....a kind of summary form. (in continuous forms view)

I wanted to be able to still update info on the summary form for one paticular field and keep all the others locked. Ie so info could be entered from either form and would show up on each.

I am sure this was working but now each time I try to enter info into this field on the summary sheet, it gives me the message "this recordset is not updatable" Aaaarghh!!!

I have checked all the allow additions / edits etc properties in the summary form and also this field is the only one which is not locked on the summary form.

Any help would be appreciated

 

[Jerry Stoner]

check your query

I'll bet you changed your query which is the recordsource for the form. Run the query from the QBE then try to edit any field from there. Youll find "the recordset is not updatable".This should at least get you on track toward finding your problem.
HTH

 

[Richio]

Yes it was something to do with the query...I think "showing the totals" but not sure.

One of those things, keep changing things until it works but then can't remember how you did it.

At least the end result is that it now works.....

Many thanks