Does a macro get built into a form or subform?

Asked by LC_Beta (1883

) May 20th, 2009

(In MS Access 2007) I have a customer form with rentals subform, which is linked to an inventory table. Everything works beautifully, but I need a warning MsgBox to appear when [Rating]=“R” that reminds the clerk to check ID (not a validation code, as we don’t have DOB for customers in their profile). Can anyone help me??

Observing members: 0

Composing members: 0

4 Answers

Ah, um. Never you mind.

LC_Beta (1883

)“Great Answer” (0

) Flag as…

Sorry your question didn’t get an answer. :(

Better luck next time, and welcome to Fluther.

augustlan (47745

)“Great Answer” (0

) Flag as…

After a couple more hours of tweaking and experimenting, I was able to achieve what I needed to do :) Although, I’m pretty sure I backed into it in a more complicated way than necessary .. not a very elegant solution, but at least it works! :) Thanks for your concern, @augustian

LC_Beta (1883

)“Great Answer” (0

) Flag as…

BTW, the answer, apparently, is that it gets built into the subform FROM the main form. Heh.

LC_Beta (1883

)“Great Answer” (1

) Flag as…