I have a Navigation Form in which the first button is defaulted to show a blank form (Request form) where users will enter information.
There's an option on this Request form that if there are multiple requests under this request, `a box is checked and another form opens (Multiple Requests).
The request number from the Request form is defaulted into the multiple request form's request number field.
On the Multiple Request window's ID field in Property Sheet/Data/Default Value I have =[Forms]![frmRequests]![RequestID]
With the Request form open on its own, this works great, but within the Navigation form it doesn't.
Is there another layer that I need to add so the default value works in either format? I will be using it in the Navigation form primarily.
There's an option on this Request form that if there are multiple requests under this request, `a box is checked and another form opens (Multiple Requests).
The request number from the Request form is defaulted into the multiple request form's request number field.
On the Multiple Request window's ID field in Property Sheet/Data/Default Value I have =[Forms]![frmRequests]![RequestID]
With the Request form open on its own, this works great, but within the Navigation form it doesn't.
Is there another layer that I need to add so the default value works in either format? I will be using it in the Navigation form primarily.