Looking for hidden code in a form

[SRussell]

I have a form that is doing some date math. StartTime EndTime and it's
diff shows in NetTime.

Of course we now need to add another "clause" to the math. Unfortunately I
can't seem to find where in the form this code is hiding??

When I change the time in the Stop textbox the value in Net changes. When I
look at the Events for the textboxes I see no reference to code. When I
went to the forms VBA, I did a search on "net" and nothing was found?

How would you locate this?

TIA

__Stephen

 

[John Vinson]

I have a form that is doing some date math. StartTime EndTime and it's
diff shows in NetTime.

Of course we now need to add another "clause" to the math. Unfortunately I
can't seem to find where in the form this code is hiding??

When I change the time in the Stop textbox the value in Net changes. When I
look at the Events for the textboxes I see no reference to code. When I
went to the forms VBA, I did a search on "net" and nothing was found?

How would you locate this?

I'd look in the ControlSource property of NetTime. There may be no VBA
code involved at all - I'd suspect that the control source is some
expression calculatting the net time.

John W. Vinson[MVP]

 

[Brendan Reynolds]

It might not be in code at all. Look at the control source property of the
'Net' text box. Perhaps it is an expression. If that's not it, check the
record source property of the form. The 'Net' text box could be bound to a
calculated column in a query or SQL statement.