Experts:
I need some help with identifying a form reference in an embedded macro. The attached database contains the following:
- Several tables and queries
- Two macros (YES -- I WANT TO KEEP THESE AND NOT CONVERT THEM INTO VBA)
- Four (4) forms
Before going into some details, allow me to recap the process for form "F10_StaffMemberList"... this one works great!
Process:
- Open "F10_StaffMemberList"
- In the top right, there's "search box"... enter, e.g., "Eastwood" and press ENTER
- The form then only shows the record for Clint Eastwood... great!
What I Need Some Help With:
- I mimicked the process "F10_StaffMemberList" and replicated it in "F20_BilletList"
- Once I open the form and enter, e.g., "Analyst", the search results an error indicating that "F10_StaffMemberList" is not referenced.
- Next, when clicking OK, reference to the macro is made with same error
I attempted the following:
- In design mode of "F20_BilletList", I reviewed any events in the Search box (I didn't see any... nor did I see any in the working form "F10_StaffMemberList"
- Next, in field [BilletIDpk], I reviewed the "Embedded Macro". Unless I overlooked it, I also did not see any reference to "F10_StaffMemberList" which should -- if available -- be changed to "F20_BilletList"
- I did the same for field [txtOpen]... again, unless I overlooked it, I didn't see a reference that should be changed from "F10_StaffMemberList" to "F20_BilletList"
My question:
I'm sure the answer is very simple as (I believe) the search box requires a simple form reference update.
Since I couldn't locate it, does anyone know what needs to change and where do I find the reference? I'd welcome if you please could attached an image so that I can easily locate it.
Again, I do NOT want to convert the embedded macro into VBA.
Thank you,
EEH