I've created a form to enter specific information into one table whose record source is tbl03ResearchClear, where I'd like to do the following:

1. On Exit from the tbl03ResearchClear.TicketNo field on the form, a text box (ctlUnpresentedItems) is refreshed with data from tbl02UnpresentedItems.UnpresentedItems where the TicketNo is equal for both tables.

2. On Exit from the tbl03ResearchClear.ResearchClear field on the form, a ValidationRule is applied that requires ResearchClear and ctlUnpresentedItems to be equal, and displays ValidationText with vbOkOnly where the result resumes data entry on the form in the ResearchClear field.

I don't know if that's enough information. I know the basics about what I want to do, but I'm very new at VB. I've been working on this all morning and it's driving me CRAZY!!!