Why is the filter now working?

[raghuprabhu]

Hi All,
First of all A Happy New Year to one and all.
I downloaded this small sample database from Allenbrowne’s site at the following page http://allenbrowne.com/AppFindAsUType.html .

I have modified it to suit my working database. I have added a new form to the sample. When a company name is searched and not found, it can be added using “Add New Customer”.

What I am trying to do is when I close the “Add New Customer” form, I am using the company name to be pasted in the “txtFindAsUTypeValue” text box, but it is not filtering and showing the record.

What am I doing wrong? Thanks to all in advance

Raghu Prabhu from Melbourne

 

[John Big Booty]

From what I can see the work is being done by the Module ajbFindAsUType. Your form AddCustomers is essentially working, it is adding the new item to the underlying table. What you need to do is work out how force the Module to refresh filtered data. This in fact happens as soon as you back space in the find value text box.

The best advise I can give you is to work through the Module and work out what each section is doing and how it works. Once you have done that you should have a far better idea of how to get the module to refresh the underlying data.