Update Open Table From Query

[brandysoda]

I was wondering if Access permits updating of fields in a table that is open through a query?

Actually, I have a form that is based on a table. I run a procedure from the form and I try to update a value in the table that supports the form. I cannot update the table through the form itself so I have to update the table directly. Is this possible ?

Let me know please. Thank You.

 

[Trendsetter]

I can't see any reason why you can't update the table through the form but even so you can use code to modify the data in the table:
Open a recordset then change the value you want then close the recordset again

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[brandysoda]

Thanks Frank,

I did manage to do what I wanted. Using a recordset was going to be my next approach. But I am glad I was able to fix the bug using the form. I appreciate your time. Thank you.