Query question

[radicalrik]

If I have a form which is based on a Query and is using 3 different tables, how would I go about updating specific records from the form into a specific table?

 

[KenHigg]

What happens when you try to change some data?

ken

 

[radicalrik]

because the form is based on a Query it will not allow me to change any fields. I want to take the data that I enter and save it to a database

 

[KenHigg]

because the form is based on a Query it will not allow me to change any fields.

This in itself should not prevent you from changing the data in the underlying tables. You must be doing something else in your query(s) to prevent you form updating the data. Sometimes summing or total a field will do this.

With out going into to much detail, I would suggest you do a new form that will be used to update data which is based on data from the first form, using the original form as sort of a look up form.

Make sense?

ken

 

[radicalrik]

I have criteria asking for the SYSTEM I want to look up. I have the criteria defined as ["Enter System Name:"]