Automatically updating Feilds.

[Sprawl]

I'm creating a submission form that launches a Query. Pretty simple stuff right .

however, I'm stumped and having a hard time how to autoupdate one feild in the form once another field is entered.


Basically. I have a report that has a "start" and "end" field. I want the user to enter the appropriate number into the "start" field, and it to automatically populate the "end" field with the exact same number. the difference is, that they can overide that 2nd number should they want to allow for a range.

 

[rainman89]

in the after update event of your start time put
me.endfield=me.startfield
should work

 

[Sprawl]

Thank you.

it needed actually one more thing, But that was the basic idea

just putting that however in the feild caused an error saying that it was an invalid Macro. However, creating an event procedure with that inside it worked.

Thank you

 

[rainman89]

Glad to hear it helped