By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,480 Members | 2,189 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,480 IT Pros & Developers. It's quick & easy.

Calling Forms From a Object within a Form

P: 3
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???
Jan 28 '08 #1
Share this Question
Share on Google+
4 Replies


P: 14
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?
Jan 28 '08 #2

P: 3
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???
Jan 28 '08 #3

P: 14
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.
Jan 28 '08 #4

P: 3
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
Jan 28 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.