editable datasheet view in subform, how to?

[jaeezzy]

Hi, I have a subform, It displays three datas, Description, Due and Dispatch. Now what I want to do is, I want the subform to display both "Description" and "Due" and in "Dispatch" I want users to be able to edit so that when a "Save" button is pressed I can update "Dispatch" column of the table with that value in a dispatch column in a subform. I found that if I query and get the dispatch column from the table directly I can edit and change the records in the table as well but this way isn't convenient coz it only updated the number dispatched not the date when it was dispatched or anything. So, I will be extracting dispatch details from the subform, date and other details from a textbox or combobox. And when everything is ready I just want to click the save button and insert and update all the details as required. So, I was wondering, how I can get the subform do that. Thanks

 

[mikebaldam]

run the query to update the data then on the ON CLICK Event of the save button add

Forms!FormName!SubFormName.Requery

to reload the data (after the query has run)

 

[jaeezzy]

run the query to update the data then on the ON CLICK Event of the save button add

Forms!FormName!SubFormName.Requery

to reload the data (after the query has run)

I think you misunderstood me. What I meant is I have a subform and have a query for it as well. Subform will display three columns from different tables. They are: "Description", "Due", "Dispatch". Description and Due, I could easily retrieve from the tables but regarding Dispatch what I have to do is, make it editable. So, users will enter in this Dispatch column their own values e.g: if the Due is 2 then user might enter 1, meaning out of 2 1 is dispatched and when user clicks the Save button this user entered '1' will be updated in the NbrDispatched column in the respected table and after this update Due for that particular item will be just 1. So, I'm wondering how I can make column such as Dispatch I've mentioned above. Hope i could make it clear. Thanks