A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Using Option group selection to call pop up form



 
 
Thread Tools Display Modes
  #1  
Old January 26th, 2005, 01:31 AM
WhitewaterJim
external usenet poster
 
Posts: n/a
Default Using Option group selection to call pop up form

I am creating an equipment inventory database. As part of the info that i
need to track, I have 3 types of lease agreements for printer devices. I
would like to create my new record data entry form so that the based on the
lease type selected by the user, only the appropriate finance field are
available. The method I have been trying to make work, is to create an Option
Group with the three lease types as the selectable options. I then attempt to
call an OnExit event that gets the value from the control source of the
option group (LeaseType Field) and based on the value, call the appropriate
pop-up form. Programming is a definate weakness for me and i think it's the
"if Then" statements that are tripping me up. any advice, or better method?
Thanks
--
Jim Keplinger
  #2  
Old January 26th, 2005, 08:55 AM
John Nurick
external usenet poster
 
Posts: n/a
Default


Hi Jim,

Guesswork and air code:

Dim strFormName As String

Select Case Me.LeaseType.Value
Case 1
strFormName = "frmOne"
Case 2
strFormName = "frmTwo"
Case 3
strFormName = "frmThree"
End Select

DoCmd.OpenForm strFormName blah blah

On Tue, 25 Jan 2005 16:31:14 -0800, "WhitewaterJim"
wrote:

I am creating an equipment inventory database. As part of the info that i
need to track, I have 3 types of lease agreements for printer devices. I
would like to create my new record data entry form so that the based on the
lease type selected by the user, only the appropriate finance field are
available. The method I have been trying to make work, is to create an Option
Group with the three lease types as the selectable options. I then attempt to
call an OnExit event that gets the value from the control source of the
option group (LeaseType Field) and based on the value, call the appropriate
pop-up form. Programming is a definate weakness for me and i think it's the
"if Then" statements that are tripping me up. any advice, or better method?
Thanks


--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
  #3  
Old January 26th, 2005, 07:37 PM
WhitewaterJim
external usenet poster
 
Posts: n/a
Default

Thanks John, I should have thought to include my code. I appreciate your
blind effort. The solution that you outline worked fine for my issue. Thanks
again

"John Nurick" wrote:


Hi Jim,

Guesswork and air code:

Dim strFormName As String

Select Case Me.LeaseType.Value
Case 1
strFormName = "frmOne"
Case 2
strFormName = "frmTwo"
Case 3
strFormName = "frmThree"
End Select

DoCmd.OpenForm strFormName blah blah

On Tue, 25 Jan 2005 16:31:14 -0800, "WhitewaterJim"
wrote:

I am creating an equipment inventory database. As part of the info that i
need to track, I have 3 types of lease agreements for printer devices. I
would like to create my new record data entry form so that the based on the
lease type selected by the user, only the appropriate finance field are
available. The method I have been trying to make work, is to create an Option
Group with the three lease types as the selectable options. I then attempt to
call an OnExit event that gets the value from the control source of the
option group (LeaseType Field) and based on the value, call the appropriate
pop-up form. Programming is a definate weakness for me and i think it's the
"if Then" statements that are tripping me up. any advice, or better method?
Thanks


--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Option Group to reports [email protected] Setting Up & Running Reports 2 January 17th, 2005 11:48 PM
Need to clear controls of Filter form Jan Il Using Forms 2 November 28th, 2004 03:04 PM
Give a botton on an Option Group Post Defualt Jan Il Using Forms 14 November 28th, 2004 06:21 AM
Option Group in Form Matt Using Forms 1 September 25th, 2004 03:01 PM
option button value in word form Optbutton General Discussion 0 June 16th, 2004 05:59 PM


All times are GMT +1. The time now is 07:45 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.