Combo box choice outcome

J

Joe Sorrentino

I have a combo box with the following choices:

Checks_Walkthrough
Checks_Monitor
Research_Case
Inventory_Maint
Task_Cable
Task_Misc
New Issue

What I want is if anything BUT "New issue" is selected, two fields in the same form as the combo box are populated by other data in the table the above list is pulled from. I can get this to happen by itself.

Me.Text27.Value = Me.imac.Column(2)
Me.model.Value = Me.imac.Column(3)

If "New Issue" is selected, I want another form 'New_case' to open and enter the required data there. I can get this to work alone also with a DoCmd open form line of code.

I just cannot figure out how to code it all under the after update event. Is this beyond the ability of Access 2007?

More likely it's beyond my minimal but still expanding Access knowledge.

Thanks for any help.
Joe



Submitted via EggHeadCafe - Software Developer Portal of Choice
Adding WCF Service References
http://www.eggheadcafe.com/tutorial...9-dfa51a9fab8e/adding-wcf-service-refere.aspx
 
S

Steve

Hello Joe!

Refine the following code to make it work for you:
If Me.imac.Column(2) = "New Issue" Then
DoCmd.OpenForm .........
Else
Me.Text27.Value = Me.imac.Column(2)
Me.model.Value = Me.imac.Column(3)
End If

Put the code in the AfterUpdate event of the combobox.

Steve
(e-mail address removed)
 
J

Joe Sorrentino

Steve:

Thanks!

Once again I was overthinking things!

Joe



Steve wrote:

Hello Joe!
17-Feb-10

Hello Joe

Refine the following code to make it work for you
If Me.imac.Column(2) = "New Issue" The
DoCmd.OpenForm ........
Els
Me.Text27.Value = Me.imac.Column(2
Me.model.Value = Me.imac.Column(3
End I

Put the code in the AfterUpdate event of the combobox

Stev
(e-mail address removed)

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Putting Twitter Realtime Search to Work
http://www.eggheadcafe.com/tutorial...24-c9960b55b669/putting-twitter-realtime.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top