Editing list boxes in form...

[Guest]

I have 120 list boxes in a form that contain the Row Source data as follows:

SELECT [TableAssignments - Member].Sit2 FROM [TableAssignments - Member]
WHERE ((([TableAssignments - Member].TableNo)="02"));

Is there a way to edit all the list boxes within the form without having to
go to each one? I need to change in all the list boxes, Member to Visitor.

 

[Duane Hookom]

You can select them all at once and change the Row Source. This would only
work if the complete row sources are exactly the same. I expect this isn't
the case since you have hard-coded values like "02".

Otherwise, you could write code to loop through all of the controls on your
form and update the Row Source properties. This would need the form to be
open in design view so the changes could be saved.

 

[Guest]

I have found this find and replace tool to be very valuable for this sort of
task:

http://www.rickworld.com/download.html