I am trying to havea form that operates so that if a certain field in my "look up" subform (the one that I use to select which record to show in the other subforms) is "0" one of the other subforms will automatically show a new record. My macro for this returns a message that the form (the one I want to have show a new record) isn't open (but it is open on my screen). Here is my macro.



condition: [Forms]![frmDataEntry]![frmFindRecord].[Form]![frmsubfindrecord].[Form]![Related Comp]

action: gotorecord

Object Type: Form

Object Name: Forms![frmDataEntry]![Test Right side].Form![frmCompilations].form

Record: New



I thought a work around might be to have my subform that I want to show a new record defaulted to show a new record. Right now it is based on a query that is sorted by the primary key autonumber from lowest to highest.



Any and all suggestions welcome (PS I'm lousy at code).