I have a problem with some of my forms...

I have some fields on this continuous form where the user has to select a Yes or No value in a combo box. I'm using different combo boxes because the form is used as a checklist.I prefer using combo boxes because it will be more clear for the users (instead of using a check box).

However, when I try to move around on this form, I always get an error message telling me the recordset is not updatable.

This form gets its data from a query. When I try to run this directly in the query I can't select any value in the combo boxes either. I guess the form is not the problem but the query is, because editing directly in the table works and the problem starts in the query.

Does anyone knows what I have to do to solve this problem? Is it possible that the query is in some kind of 'read only'?

Some queries are not updateable. I usually don't base forms on queries, although some people prefer it, so I am not too familiar with the rules here. This is a limitation in SQL Server as well, so it involves the SQLanguage, and not Access, either. I would suggest a review of updateable queries.

Can you create the form on a table? If the table contains look ups, the record will be updateable.


mmcdonal

The query's SQL is the following:

SELECT TOP 10 tblTestBuy.Datum, tblTestBuy.Artikelnummer, tblArtikelen.Artikelnaam, tblTestBuy.Ptag, tblTestBuy.Volledig, tblTestBuy.Kwaliteiten, tblTestBuy.Koopinstructies, tblTestBuy.Voorradig, tblTestBuy.Invoerdatum, tblTestBuy.Afdeling
FROM tblTestBuy LEFT JOIN tblArtikelen ON tblTestBuy.Artikelnummer = tblArtikelen.Artikelnummer
WHERE (((tblTestBuy.Datum)>=Date()-6 And (tblTestBuy.Datum)<=Date()) AND ((tblTestBuy.Invoerdatum)=Date() Or (tblTestBuy.Invoerdatum) Is Null) AND ((tblTestBuy.Afdeling)="BA06"))
ORDER BY tblTestBuy.Artikelnummer;

I don't know if this can be put into the form and if yes how... I guess the on open event or on load event has to be used, but I don't know how to insert this...

Found another way to make this work. I'll have to create much more tables, query's and forms that I wanted to, but it seems to work that way so...

Thanks for trying to help