Recent content by revkev6

I am using the "after update" event in a text box to call a macro. the macro first calls the function to requery..... wait a minute... the lightbulb just went on. with the dirty code saving the data I dont need to requery! duh! I just pulled all the requery code out and left the dirty code and...

playing a bit more, if I move the brecalc() from the form module to module1 it doesn't like the Me. reference. Should I have the function call and brecalc() in the form's module or in a separate module?? it is very odd to me that it worked fine just a few minutes ago....

it does, thank you but somehow I managed to screw it up and I have no idea what I did. I had been playing around with where I should have the code. I initially put it in "module1" but when it wouldn't work I put it in the Form module. I forgot to remove the code from module1. I added the code...

that worked perfect!!! now, what did it do?? I'm mostly self taught, I have no idea what "dirty" means!

yes, the form is bound. I am calling a query in my macro that updates the records in the table. I am able to use [forms]![process development1a]![recordnum] in the query to get the current record I am accessing from my form. I guess that is why I need the form to add the record to the table...

yes, I initially tried a save and a repaint/refresh. with no luck.

Hey all this is my first post here but I have found many of my answers to google searches on this forum so hopefully you can point me in the right direction! I have a linked form setup where a person enters a due date and the number of weeks it will take to accomplish. A macro subtracts the...