Tick box code when value = ###

[james_IT]

hi,

what would the code be if i wanted a tick box called 'paid?' to be true once a field on my form called 'amount outstanding' = £0?

thanks

 

[Matt Greatorex]

If [Forms]![[I]form name[/I]]![Field Outstanding] = 0 Then
       [Forms]![[I]form name[/I]]![Paid] = True
End If

 

[Rich]

Why would you want to store redundant data?

 

[james_IT]

thanks for your reply...where would the code go? i tried it on the after update event of the field outstanding and nothing happened?...

If [Forms]![frmAddNewEvent]![Outstanding] = 0 Then
[Forms]![frmAddNewEvent]![Paid?] = True
End If

 

[RuralGuy]

James,
Here's some links you might want to review:
List of reserved words in Access 2002 and Access 2003
List of Microsoft Jet 4.0 reserved words
Special characters that you must avoid when you work with Access databases
What Rick was saying is that if you can calculate the value of the "TickBox" then you don't need to waste disk space on a field. In fact, it is important that you do not waste the disk space. Do *not* store calculated values!!

 

[james_IT]

ok i understand. but where would the code go? in the after update event of the outstanding balance field? also, before to search for outstanding payments i just made a query that searched for all the Paid?=False. How can it be done now that i am not storing the field Paid?

thanks

 

[RuralGuy]

Since you have already decided that Paid means Outstanding = 0 then look for [Outstanding] <> 0. What causes the [Outstanding] field to get its value? You may be fighting a slight design SNAFU.

 

[james_IT]

basically:

sub form total (calculated)
then discount (unbound/recorded)
then total (calculated by subform total - discount)
then deposit (unbound/recorded)
then balance paid to date (unbound/recorded)
then amount outstanding (calculated by total-deposit-balance paid to to date)

 

[james_IT]

ive removed the Paid? field from my tables and forms - it is now calculated in the forms.

my only problem is with these outstanding payments...

i fear i may be facing a structure/design problem?

 

[Rich]

Use queries to calculate outstanding invoices etc., you can then base a form/report on the query to display them

 

[james_IT]

perfect - done that.

it wont let me enter a criteria for calculated fields in a query. i want to enter >0 for amount outstanding and it just asks me to enter a value for another calculated field...?