How to filter the records while running the form?

chandrurec

Hi all,

I am trying to open a new Form named "Update Indent" from the current Form "Indent".When I open the "Update Indent" , this form should be filtered with Document No available in the current Form "Indent".

Is it possible to do this filter in the new form opened based on the Document No value available in the current form?

Thanks in advance.

Regards,
Chandru.

navuser1

Yes. It is possible.
Make relation between these two form.

diptish.naskar

Hi,

Pass the Indent No. to the update indent form using a custom function and then on the OnOpen form of the Update Indent set the filter to the Indent No. passed.

Hope this will help you!

kine

diptish.naskar wrote:

Hi,

Pass the Indent No. to the update indent form using a custom function and then on the OnOpen form of the Update Indent set the filter to the Indent No. passed.

Hope this will help you!

Why so complicated way? You can do it just by setting the RunFormLink property on the calling button/menubutton item.

Andwian

kine wrote:

Why so complicated way? You can do it just by setting the RunFormLink property on the calling button/menubutton item.

LOL that's kool! =D>

RunObject: Form Update Indent
RunFormLink: "No."=FIELD("Document No.")