You need a field on a form to show something in that form, not for passing a variable.
1. Create a function on your new form, declare your new form as a variable, call the function on the form variable before calling mynewformvariable.RUN (or .RUNMODAL)
2. Build a filter string '*|yourZipCode', set a filter on some existing (and non-pk) field using this filter, then in OnOpenForm retrieve the filter using GETFILTER(field) then parse returned string retrieving yourZipCode.
Second option is more complicated but can be used with construct FORM.RUN(yournewformID, filteredrecvariable)
- add new field in source table of new form, set as flowfield with calcformula that targets the zip code field in table sales header ... or ...
- create new function SetZipcode(zipcode) in new form. call that function in sales order form before you run the new form out from sales order form.
best regards
Franz Kalchmair, MVP
Alias: Jonathan Archer
Answers
1. Create a function on your new form, declare your new form as a variable, call the function on the form variable before calling mynewformvariable.RUN (or .RUNMODAL)
2. Build a filter string '*|yourZipCode', set a filter on some existing (and non-pk) field using this filter, then in OnOpenForm retrieve the filter using GETFILTER(field) then parse returned string retrieving yourZipCode.
Second option is more complicated but can be used with construct FORM.RUN(yournewformID, filteredrecvariable)
Regards,
Slawek
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
Can you elaborate more.I didn't understand.please
- create new function SetZipcode(zipcode) in new form. call that function in sales order form before you run the new form out from sales order form.
Franz Kalchmair, MVP
Alias: Jonathan Archer
please like / agree / verify my answer, if it was helpful for you. thx.
Blog: http://moxie4nav.wordpress.com/