Update text box with control source

[Edgarr8]

Hi guys,

I have a form which has a summary or information I want.

Ranch, Irrigation Date, Irrigated Hours, Gallons Per Minute, etc.


From this FORM i created a sub form, that list all the blocks in that ranch and adds the data already in the first form.

I figured i could set me textbook to be a controlled source from the first form to grab all my values.

But the problem is that one in a while a block is not irrigated the same as all the other blocks so i want to be able to change it in the subform. But since its a control source I am not able to do so.


How can i have it grab the value from the first form, and also make it updatable if needed?

 

[boblarson]

Have a form to be able to update and then call it when you double-click on the field in the subform. It can then open up as dialog and requery the subform in the close event of the popup form.