Make form for update query?

[Smack]

Can I make a form out of an update query?
I have re-configured a canned program and am doing updates on the backend. It would be a HUGE help if I could create a form or a prompt to enter info in i/o entering date into the criteria/update to fields.
Thanks , JRS

 

[willir]

Smack

Two thoughts...
- Would a parameter query work? Much simplier than creating a form. The parameter query could be nested.
- You can change the update query to a standard query, and then use it to create a form. This would create your form, but I dont think it is what you are looking for.

Richard

 

[Smack]

Parameter as in a select Q prompting you to enter info? Don't know anything about nesting. I am updating 4 fields at a pop and 2 tables.
Example, training table has 425 records, 3 fields get updated. Employee training table has the training title in it, this has over 10,000 records.
Updates =
table 1
training name, document number, classification
table 2
training name
I have linked both tables by name in the query.

 

[willir]

Smack

Does the Employee training table reference the Training table, or uses the title?

For example...

tblTraining
CourseID
CourseTitle
...

[blue]A[/blue]
tblEmpTraining
EmpID
CourseID
...

or
[blue]B[/blue]
tblEmpTraining
EmpID
CourseTitle

In the first example, by changing the title in the Training table, no change would be required in the Employee Traning table.

In a similar fashion, the schedule could be referenced from a schedule table, etc.

Back to the nested parameter query...

[blue]Update query qryChangeName[/blue]
UPDATE tblEmpTraining SET tblEmpTraining.EmpName = [Enter New Name]
WHERE (((tblEmpTraining.EmpName)=[query]![qryName]));

[blue]qryName[/blue]
SELECT tblEmpTraining.*, tblEmpTraining.EmpName
FROM tblEmpTraining
WHERE (((tblEmpTraining.EmpName)=[Enter Name]));


Richard