How do I update a feild with

[Krash878]

Can I make a form update two feilds on a table at the same time?

I have a form that I enter data in to. It does a function that compares data and then does a math question and posts the answer in a feild. When that feild is filled I want another field to be changed from no to yes. Can someone give me a kick in the right direction. I can supply more info if needed.

Thanks
Kenny

 

[cavok]

Assuming the function returns null if any fields are blank, something like this should work:

field1 = somefunc()
field2 = not isnull(field1)

You could place it in the afterupdate proc of all fields contributing to the answer or the beforeupdate proc of the form depending on your requirements. You could also build it into the function itself.