Search results

that does help some. i'm looking to have a rolling 29 day total for cashier variances (unique ID, all positive intergers from tblVariance) displayed in my subform (sfrmVariance) when the information for the employee is pulled up (from tblMasterStaffList) and then updated when a new variance...

please, i think this could help me with my current problem. :D

i'll give it a shot. thanks!

I need some help. i'm trying to track a rolling 30 day variance total (per staff member) and show the results in a form. I can run a report that shows every instance and a total at the bottom but instead of opening a 'view report' window i just want the 30 day rolling total to be in the form...

so what about the rest of us?

i am having the same problem with the changes, it gives me a runtime error... any suggestions?

duh, i had some code switced around. i just put the code you gave me in the 'on open' for the new form, works like a charm! thanks a million!

yeah, i get a runtime error. thanks though. i have the login form as the first form the user encounters, then when they click on the enter button (after the name and pass are validated) it loads up the second form. it's on the second form that i want the username from the first form to be...

thanks for the help. i just want to get the username that they typed into the login box (different than the network login) on one form to populate a username on another form. i'm sure there is some simple code i could use to make that happen, right? Rob

how would i do the same thing but from 2 different forms? i have a login form and i want the username from there to transfer to a second form. thanks a million!