Thanks for the idea. I put my statement in the criteria of the box I want to update and the query gets no errors!!! The only problem now is it just pulls the null values from the blank table that I want to update. Ive tried an update and append query and it does the same thing. Where did you put...
I don't have a query, im just pulling it from a table. If I did the if/then from the query does it work better? I made my statement in the expression builder, so im sure the names are right. I may end up calling Microsoft today. I've looked on technet and havent found anything that can help...
I have a form that is supposed to go to a table and bring in the value of a cost IF the study and visit number match. This doesn't seem that difficult, but I keep getting a name error. If there is a problem with my code below, please let me know. I may just try running a query if all else fails...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.