How to make an editable query?

[cmb]

Hi there,

I am currently making my 1st database and have hit a brick wall on something that I thought would be very simple. I have a query using two tables, tblOrders and tblSites. tblOrders holds the data for upcoming installations of new equipment and tblSites holds the data for the site name and address etc. My query matches the site to the order and works perfectly. But I can't edit the results which I need to be able to do in a form.

Would someone please be so kind and explain why this is and how I can get around it. If it makes any difference the form will need a bound subform with a 3rd table, tblAppoints. This is to allow the user to view, add and change appointments associated with the installation.

Many thanks in advance!

CB

[burrina]

Are the tables linked in your query? Can you post a screenshot or the sql? Do you get an error message and if so, what is it?

[cmb]

The SQL is below. There are no error messages, I just cant make any changes. For example, there are two combo boxes and I can see all the choices when I click on one but I cant change them. Thanks for the help!

SELECT tblOrders.OrderActivity, tblOrders.OrderRequest, tblOrders.OrderNode, tblOrders.SiteID, tblOrders.OrderDesc, tblOrders.OrderPO, tblOrders.OrderNotes, tblOrders.OrderComments, tblOrders.OrderStatusID, tblOrders.OrderID, tblSites.SiteName, tblSites.SiteAddress1, tblSites.SiteAddress2, tblSites.SiteCity, tblSites.SiteState, tblSites.SiteZip, tblSites.SitePhone, tblSites.SiteEmail
FROM tblSites INNER JOIN tblOrders ON tblSites.SiteID = tblOrders.SiteID;

[burrina]

I don't see the problem! I can easily add/edit records with that sql. What is the code for the combo boxes and are they the fields that you can't edit?

[cmb]

I could not change any records and finally find the cause... The primary key in tblSites had somehow been deleted. Thanks again for your help!

[burrina]

Glad you got it working. Good Luck With Your Project.