ajaymansata
Registered User.
- Local time
- Today, 00:20
- Joined
- Dec 17, 2001
- Messages
- 25
is it possible that i open a form and on clicking a button another form is opened.how do i do it
opening a form from a form
- Thread starter ajaymansata
- Start date
Graham T
Registered User.
- Local time
- Today, 00:20
- Joined
- Mar 14, 2001
- Messages
- 300
ajaymansata,
If you are unsure of how the best way to do this is then you should use the wizard when placing the command button on the first form.
Work through the steps of the wizard, choosing the form to be opened > how the form is opened (at specific record or show all records)
If you choose to open at a specific record then you will need to specify the related fields.
Work through the rest of the steps and see how you go on.
HTH
If you are unsure of how the best way to do this is then you should use the wizard when placing the command button on the first form.
Work through the steps of the wizard, choosing the form to be opened > how the form is opened (at specific record or show all records)
If you choose to open at a specific record then you will need to specify the related fields.
Work through the rest of the steps and see how you go on.
HTH
Accessable
Registered User.
- Local time
- Today, 00:20
- Joined
- Dec 5, 2001
- Messages
- 20
Yeah.
You see, this is done with coding. But Access makes this easy for newbies by doing all the coding for you.
After the button is added, if you use the wizard as suggested, look at the Event tab of the properties window for your new combo box. You may notice that the On Click event has an Event Procedure in its field. You may look at the code that Access wrote for you by clicking the button with the three dots (...) in the On Click field.
You will come back to this a lot in the future, as you get more comfortable with code (or maybe not). Access does a good job at simple things like opening forms. But for added flexibility and options in the future, homemade code can be very useful. For fun, you may try messing with the code on a temp db.
-Mark
[This message has been edited by Accessable (edited 02-21-2002).]
You see, this is done with coding. But Access makes this easy for newbies by doing all the coding for you.
After the button is added, if you use the wizard as suggested, look at the Event tab of the properties window for your new combo box. You may notice that the On Click event has an Event Procedure in its field. You may look at the code that Access wrote for you by clicking the button with the three dots (...) in the On Click field.
You will come back to this a lot in the future, as you get more comfortable with code (or maybe not). Access does a good job at simple things like opening forms. But for added flexibility and options in the future, homemade code can be very useful. For fun, you may try messing with the code on a temp db.
-Mark
[This message has been edited by Accessable (edited 02-21-2002).]
