As we all know if you have a form whose record source is a query with more than one table. You cannot update a field cause it says recordset not updatable.<br>But If I add a OnClick Event to th eform so that it writes the one field to an unbound test box. Then change that value click and Update button which write's that new value back to the one correct table using OpenRecordset commands then refresh the form you can change the value in-directly. <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
A work Around for Updating a form attached to a query.
- Thread starter DougP
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question