On Change Search

[Michael Malone]

Anyone have any ideas on how best to implement an On Change search?

What I want to accomplish is this:

Unique Order Number: 12345

User changes the unique order number, form goes to either the new number if
it exists, or creates a new record.

My problem doing this in the past was that if you would change the unique
order number, it would write it to the record so that the initial number
would be gone, and just the new number would exist. I can't remember how I
solved this in the past, but I think it had to do with storing the original
value in the control somehow...

What a drag it is getting old.....<grin>

Thanks for your help!

Mike

 

[Marshall Barton]

Anyone have any ideas on how best to implement an On Change search?

What I want to accomplish is this:

Unique Order Number: 12345

User changes the unique order number, form goes to either the new number if
it exists, or creates a new record.

My problem doing this in the past was that if you would change the unique
order number, it would write it to the record so that the initial number
would be gone, and just the new number would exist. I can't remember how I
solved this in the past, but I think it had to do with storing the original
value in the control somehow...

A search text box really needs to be separate from the
form's data. This means it should not be in the detail
section and it definitely should be unbound.