if and then in a form
in [Forms]
|
From: deb on 18 Apr 2010 21:48 thank you Tom, for making me think about it more - now i understand it better :) -- deb "Tom van Stiphout" wrote: > On Thu, 15 Apr 2010 19:26:01 -0700, deb > <deb(a)discussions.microsoft.com> wrote: > > Why not make today the day you write your first code? All Access > programmers eventually have to. > It starts with selecting the right spot to write your code. In this > case the AfterUpdate event of your Combobox. It fires after the user > makes a selection. Open the Properties window, select the combobox, > select the Events tab, and click on the ... button next to > AfterUpdate, choose Code Builder, and write this code: > if Me.myCombobox.Value = 1 or Me.myCombobox.Value = 2 then > Me.myInputField.Enabled = False > else > Me.myInputField.Enabled = True > end if > (of course you replace myObjectNames with yours) > > -Tom. > Microsoft Access MVP > > > >i'm guessing its a macro - not my strong point > > > >i want to grey out an input field based on a combo box selection > > > >so if they select option 1 then box 2 is unavailable and vice versa > . > |