Filter data tablebox based on textbox data

ResenderResender Member Posts: 119
edited 2011-11-23 in Navision Attain
Well I solved the problem that I had so I'm changing the post to share it rather then have the question here for all 'eternity'.

I had a form that needed some change, you had to be able to fill in a barcode and that had then to retrieve the location of the packet.
On the form was already a tablebox showing all valid locations, the idea is after a location is found to show all the records lining to this location.

Beneath is the solution,codLocation is a code 20 global variable, shown in a textbox called txtboxLocation.When a valid location is found or the OnAfterValidate() of the location textbox,
a function is called that executes the following:
IF codLocation <> '' THEN BEGIN
SETRANGE("Location Code",codLocation);
END ELSE BEGIN
SETRANGE("Location Code");
END;
CurrForm.UPDATE;

So this will set the range on the source table of the form to the found codLocation, if a valid one is found.
If codLocation is empty,either because none was found or because you emptied the Location textbox, all the records will be shown.
Sign In or Register to comment.