Calling Forms From a Object within a Form

[rghaffari]

Can someone help me please. I am trying to call another form from one of the attributes with in a form to create changes with in the database. what is the command for this procedure with in Access please???

[TerryDM]

Please give more detail. An attribute is a setting than is either made or read - there is no action associated with it. To what action are you trying to invoke a form? What are the filter criteria that you want to be used when the form is opened?

[rghaffari]

Hey Terry,
Thank you for responding. Now what I have is a variable which is a list of values from a table. What I have to do is when the item changes and matches a certain criteria, the record has to be deleted from the 1st table and the same record is to be transferred to the second table. Now I want to do this either by invoking another Form and do all the changes there or just inserting the record to the 2nd table and then delete the record from the 1st one. The Trigger I will be using is on the EVENT Tab and is called AFTER UPDATE, which I feel is the most appropriate trigger. Now if I am going to call a new FORM, I will be using the ON CLICK Trigger and if I am using the INSERT and DELETE mode then the AFTER UPDATE Trigger. Now I want to know, is the command to invoke a new FORM from this ITEM, if possible please???

[TerryDM]

Hey Terry,
Thank you for responding. Now what I have is a variable which is a list of values from a table. What I have to do is when the item changes and matches a certain criteria, the record has to be deleted from the 1st table and the same record is to be transferred to the second table. Now I want to do this either by invoking another Form and do all the changes there or just inserting the record to the 2nd table and then delete the record from the 1st one. The Trigger I will be using is on the EVENT Tab and is called AFTER UPDATE, which I feel is the most appropriate trigger. Now if I am going to call a new FORM, I will be using the ON CLICK Trigger and if I am using the INSERT and DELETE mode then the AFTER UPDATE Trigger. Now I want to know, is the command to invoke a new FORM from this ITEM, if possible please???

In the AfterUpdate event use the following code snippet:

DoCmd.OpenForm "frmXXXX"
DoCmd.OpenQuery 'insert'
Docmd.OpenQuery 'delete'

This can be done with a macro also which can run the queries, but it doesn't seem like you need the form.

[rghaffari]

In the AfterUpdate event use the following code snippet:

DoCmd.OpenForm "frmXXXX"
DoCmd.OpenQuery 'insert'
Docmd.OpenQuery 'delete'

This can be done with a macro also which can run the queries, but it doesn't seem like you need the form.

THANK YOU TERRY AND GOOD NIGHT