Hi John and thanks for helping :^) I'll create a form and try out your solution but is there no other way to do this without using forms? to set these things in the table itself?
thanks, Dimitris --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > Dimitris- > > In the Current event of the form, do: > > If Not (Me.Absent) Then > Me.Score.Enabled = False > Me.Success.Enabled = False > Else > Me.Score.Enabled = True > Me.Success.Enabled = True > End If > > In AfterUpdate of Score, do: > > If Me.Score > 70 Then > Me.Success = True > Else > Me.Success = False > End If > > In AfterUpdate of Absent, do: > > If (Me.Absent) Then > Me.Score.Enabled = True > Me.Success.Enabled = True > Else > Me.Score = Null > Me.Score.Enabled = False > Me.Success = Null > Me.Success.Enabled = False > End If > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of Dimitris > Sent: Thursday, December 22, 2005 7:25 AM > To: [email protected] > Subject: [ms_access] if score > 70 then succes = No # How do I do this? > > Hi, > > I have a table with fields "score" of type integer, "success" of type > Yes/No and "absent" of type Yes/No. > > When "score" gets a value bigger than 70, "success" must be > automatically set to "Yes". Furthermore, if field "absent" becomes > "No", "score" and "success" must not allow a value to be entered. > > How do I do this? > Thanks in advance, > Dimitris ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income homes are not online. Make a difference this holiday season! http://us.click.yahoo.com/5UeCyC/BWHMAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
