Modify form

[kkeegler]

I am a newbe - so here goes.

I need to change a product I sell to another name, i.e. ReTrace to No Record.
Is there way to locat all instances of "Retrace" in Tables, Forms, Reports, SQL statements etc and simply change it to "No Record"

Similar to the Find Replace option.

I already tried looking in each place I could find to make the change and that didn't work. I must have overlooked 1 or 2 instances of "ReTrace". I ended up with the #Name as my price code instead of $00.00

 

[Pat Hartman]

If you are having to search objects such as field names and control names for this value, you have not designed your table properly. Product name should be a field in a table and you should only have ONE place to change it. I'll bet that if you added a new product to your product line, you'd need to change everything also. If that is the case, perhaps you'd like to step back and start again with correct table structures

It never gets easier to make a major structural change like this. But, the more objects you build and the more data you add, the harder it gets to change.

 

[kkeegler]

Modify Form

I guess you need more info.
I know how to change lables, field names etc.
The currency field and product name sets the price on that product and the field name passes to my customer invoice after a few calculations such as totals with other purchases, sales tax calcs. etc.
That is why the name I need to changes is in other places and objects.

 

[kkeegler]

Resolved...spelling error located