creating update forms

[k2hansen]

I am trying to create a form that will update multiple tables simultaneously (ie one entry will populate fields in several tables)in order to decrease the ammount of typing involved. If someone has done this or something similar I would appreciate an assist. Feel free to e-mail me with any responses. I need responses as quickly as possible.

 

[Melody]

I'm trying to do something similar to this, but it would not let me add records to the form. I then thought that because it was a query, you can't add anything, you could just pull the data in from your tables, not put your data from the form INTO your tables. Am I wrong, can a query-based form update multiple tables???

 

[alxj]

You might want to try altering the type of query.

The default query type is a select query which will view the underlying data but not allow you to change it.

Try selecting an update query or an append qery and see if you have better results.