Recent content by Confused re: Access

I have no idea how to do that. I'm concerned that I've spent too much time on this as it is, and you have spent plenty of time as well. I think I'll just make it a manual check box and check it myself if I have additional parts. Thank you for your time and attempts to help.

Yes, I am positive. Here's the code, entered in the "After Update" in the Events tab of the Qty 2 object (with carriage returns everywhere there's a line break): If IsNull(me![RMA 2013]![Qty 2]) Then Me![RMA 2013]![Additional Parts?] = 0 Else Me![RMA 2013]![Additional Parts?] = -1 End if When...

That didn't work either. Is it possible I need to create a macro? It keeps telling me it can't find the macro. BTW, thank you so much for continuing to try to help me out with this.

It seems I was correct about my names. It also seems I was entering the code in the correct place. Now I'm not sure what to do. I need the "Additional Parts?" object to be checked when someone inputs a quantity in the "Qty 2" object in the form.

I got the same error with that change. Qty 2 is the name of the field. I'm not sure what a textbox is. Isn't that just a box with text and not necessarily a piece of the table? I will make a note of no spaces in field names. Thanks!

Thank you for the reply, but when I did that, I got this error message: Microsoft Office Access can't find the macro 'If IsNull(me!Qty 2) then me.' The macro (or its macro group) doesn't exist, or the macro is new but hasn't been saved. Note that when you enter the macrogroupname.macroname...

I am new to the forum, and to Access 2003 (the version I'm using), and I hope I have put this question in the right place. I'm using a form, but based on my research, I think I need to create a query, so here's my question for the community: I have a 4-part form divided into tabs. I have a...

I'm new to Access. I just got a promotion, and part of my job is designing and revamping Access forms. I find the program rather confusing as I've had no formal training. I have found a lot of answers to my questions in this forum, but now I've hit a wall. :banghead: I am usually a lurker on...