Assigning a value from a function to a textbox on a form 1

[AccessStudent]

I'm creating an employee from which has all the employee info and then a sub form that lists all the weeks that they have worked and the hours worked.

From the sub form, I call a function that is created in
a module to calculate gross pay for each weekending. From here, I want to show this value in the subform in a column(textbox) that I have added.

How do I assign the Gross pay amount to that column(textbox) in a sub procedure, after all calculations are done?

 

[DougP]

I suspect you are talking about having a "Bound" text box
which therefore cannot have a forumla too.
I sometimes use the After_update event of the previous text box.

Me!Text1 = YourFunction(Values)


DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive