Dear All,
my form search command button won't working while input the first three or more character of tenant name the search button won't yield a result.
Please assist me in attached form.
Rgds,
aligahk06
Dear All,
my form search command button won't working while input the first three or more character of tenant name the search button won't yield a result.
Please assist me in attached form.
Rgds,
aligahk06
Can you explain your problem. Searching for records using the textbox and the Search button seem to be working.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
while entering in text box three or more character of tenant name then clicking on search command button it won't give the result of tenant related records.
Hi
Why not use the standard Combobox Search which is the usual way of doing this.
See attached.
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
Sir,
Right but i have more than 500 tenants so it is difficult to filter tenantb among 500 or more lists.
So . i want a solution based on search command.
Have you tried it with your list?
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
1.For above sopme tenant have more than one unit.
for ex- Rlounge have three unit under one tenant name.
2. After selection the tenant how can i clear the selected text in combo box. so that it show only blank and then i select the tenant from the list.
Sir,
thank you for your time
Hi
If 1 Tenant has more than 1 Unit then your table structure is wrong
You need a table for Tenants and then a related table with Tenants Units
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description