Forms – creating a warning message (2000)

Topic

New Reply

One of my forms was created from an underlying table with just three columns regarding maintenance fees. If there is a maintenance fee owed, in other words an amount greater than 0 in the fees due field, I want a warning message to appear stating this. Can I creat a control box (not sure if using the correct word) in the form that has a rule such as “if field called dues owed amount is greater than $0, show this message.” As you probably have guessed I am not very familiar with Visual Basic, but can be walked through it. I hope this makes sense. Thank you. Dorothy

Reply | Quote

Replies

If you want to display the warning on the form itself, you don’t need code. You can place a text box on the form with the following Control Source property:

=IIf([Dues Owed]>0,"Note: there are fees due!")

where Dues Owed is the name of the field. Make the text box transparent, with a transparent border, and set its Enabled property to No and Locked to Yes.

Reply | Quote

Thank you Hans. It worked great! Thank you.

Reply | Quote