Auto Enter/Validation in Find Mode

[rohksie]

Hello I am not really sure about this, I've tried checking it but maybe I didn't do it thoroughly enough. Is it possible to have validation or auto enter in find mode? The most important fields in my database are serial numbers and work orders. In find mode, I want it to be either auto-entered the same way it does on my data entry. I have a calculation to auto enter, and it replaces the value that the user types in to the correct format but it seems it only applies during data entry. In find mode,if I don't have that serial formatted the same way I get a " no matches found and modify. " Or at least a type of validation so when user exits the field or tabs into the next field during find, validation will kick in and show that it is in the incorrect format. I am a little confused and I hope someone can help. Thanks in advanced!

[Techphan]

In find mode, I want it to be either auto-entered the same way it does on my data entry. I have a calculation to auto enter, and it replaces the value that the user types in to the correct format but it seems it only applies during data entry.

 

 

Place a global text (or number) entry field on your layout, have the user enter a/the number and then manipulate that global field the same way a serial number is generated.

 

Then use the resulting number (after you have reformatted it) to run the search.

[rohksie]

thanks for the help but i don't quite understand it, would you mind telling me how to go about doing it? so make the global field equal whatever that enterable field is then run the search? I kind of understand but still am confused.

[Techphan]

Make a global entry field (the same format as your user would enter that you then manipulate as you said earlier - so it would probably be a text or number field).

 

Then place a button attached to a find script:

 

Go to layout (MyRecords)

Enter Find Mode

Set Field (MyRecords::SerialNo;Global::Entry*(whatever factor you do to the serial number) )

Perform Find

[Do more things here in the script if you need to]

 

 

To be any more useful perhaps you could give us an example of exactly what manipulation it is that you perform on the data entry field as you previously said.