Forum Discussion
Updating a field in a Form 1 using button in Form 2
Hi! I'm trying to update the data in a field in my Form 1 by clicking a button in Form 2. Total disclosure: I'm not good at coding. Whatever codes I got, it's from Google. So, in Form 1, I ha...
Hi, thank you for the info, that did make sense. I actually do have a function that returns the number of working days between StartDate and ResolveDate, and this is the value that gets thrown into DTR. And yes, what you said is the problem that I have now haha.
If you don't mind, just a few clarifications on the query. What type of query would it be? Also, what is in [somefields]? I'm assuming [sometable] is the database I'm currently using.
Thank you!
If you don't mind, just a few clarifications on the query. What type of query would it be? Also, what is in [somefields]? I'm assuming [sometable] is the database I'm currently using.
Thank you!
This is a SELECT query (as the first word in the SQL statement suggests :-)).
With [somefields] I mean you would select some fields to be returned by your select query.
With [sometable] I mean the table you select from (the one with StartDate and ResolveDate).
With [somefields] I mean you would select some fields to be returned by your select query.
With [sometable] I mean the table you select from (the one with StartDate and ResolveDate).
OMG IT WORKED!! Well, I had to tweak it a bit, but at least I got it to work haha.
Thank you so much!!!