UD form enter value in key1 textbox press tab not returning record

Epicor ERP 10
, ,
1

I have a custom form for UD40 table.
I hid all of the key fields except for key1.
I have the search button on the form and can search that way or I can use the binoculars.

What I would like to happen is the standard UX on this form as what happens in others.
I would like to enter a value into the key1 field and hit the tab key to trigger a db call and to return the record. Or to prompt to create a new record if a record with that value for key1 was not found.

Can anyone point me in the right direction? Not asking for someone to do this for me. Are there any tutorials that would cover this?

2

In customization for keys2 through 5 set the visible property to false. Just click on the textbox and the properties will show. Then towards the top you will see the visible property.

3

Mike,
Thanks for your response. I have already hidden the fields I didn’t need and added groups and labels and textboxes with correct binding.
I would like to trigger a database call and return the record where key1 equals the value entered into the txtKeyField textbox.

4

I am on 10.2.500 and when I do that it works as you want it. I tried with UD40 also.
Try a blank customization and select hidden for those 4 other keys textboxes.

5

I’m on 10.2.300.13 in my production environment but I have a DEV environment running 10.2.700.5 and will try it there and report back.

6

Here’s what I found in 10.2.300.38

Base Form - Key1 through 5 are visible

  • Entering a value in Key1, then tabbing through 2, 3, 4, and 5.
  • After tabbing out of 5, I get the “Record not found. Add new?” dialog

Customized - Key5.Visible = false

  • Entering a value in Key1, then tabbing through 2, 3, and 4.
  • After tabbing out of 4, I get the “Record not found. Add new?” dialog

Customized - Key5.Visible = true (the normal setting), Key5.Enabled = false

  • Entering a value in Key1, then tabbing through 2, 3, and 4.
  • After tabbing out of 4, the cursor jumps to the Description field (bound to Character01)
  • I do not get the “Record not found. Add new?” dialog

Customized - Key5.Visible = true & Key5.Enabled = true (both the normal setting). Key5 textbox’s Tab stop set to 100.

  • Entering a value in Key1, then tabbing through 2, 3, and 4.
  • After tabbing out of 4, the cursor jumps to the Description field (bound to Character01)
  • I do not get the “Record not found. Add new?” dialog.
  • The Cursor is in Description field, but it is not yet enabled (because no blank record yet).
  • manually placing the cursor in Key5 *via mouse click), then tabbing out, and I get the “Record not found. Add new?” dialog.

Setting the visibility of keys 2 - 5 to false, does exactly what you’d expect.

Make sure none of the existing records have any values in Keys 2- 5.

7

BTW - Setting the key’s’ visibility to false, will hide them when the form loads. But as soon as a record is created o retrieved, they reappear

UDForm minimal keys

Instead of using the Visible property, use the Customization Wizard -> Set Extended properties, to set IsHidden = true for Keys 2 through 5. That also automatically hides the labels too.

UDForm minimal keys (2)
UDForm minimal keys (2)738×395 112 KB

8

@ckrusen thanks for the gifs. So i followed your steps but I still had to tab multiple times to get the dialog.
But when i then set Tab Stop to false then it works!

1 Like