Simple Find Not Retuning Values

Classic Servoy
1

I have a dialog box that allows a search request. I can search on any of the fields (populated by globals), with the exception of the account ID field / global.integer1;

The global.Integer1 field has a value list that displays the account name and returns the account ID, (I use it all over my solution). I can see that I am not geing a value to return in this field when I select an account.

I must be missing something simple?

controller.find()
account_id = globals.Integer1;
product_sales_order_status = globals.Text1;
product_sales_order_number = globals.Text2;
sales_rep_id = globals.Current_User_ID; // Sales Rep Filter
controller.search()
application.closeFormDialog();
forms.SalesRepPSFListing.controller.show();

2

OK, If I change the filed type to combo box instead of Type Ahead, it works fine. Is this the expected behavior?

3

Can it be that any of the other fields holds an unwanted value (eg 0 or anything else in globals.Current_User_ID) without you wanting that?

4

Does not make sense it it works fine with a combox, I will just use a combo box for now. Seems something to do with the the field type / int.

Thanks