nuBuilder Forum

I have a form that works perfectly with some custom code in Before Browse, Before Open and Before Save. However it only works when I use
SELECT * FROM table
The table has a column with only 3 different values so I wanted to make 3 different forms. When I add a WHERE statement like
SELECT * FROM table WHERE column = "value"
The browse page shows the correct records, but when I select a record I get
(nuBuilder Before Open) of formname : Error Reference: 757e7c5
An error occurred while running the following query:
DROP TABLE IF EXISTS ;

If I remove the WHERE statement from the form SQL all works well. What am I missing? Is there a better place to put the WHERE, or a filter? I've only been using nuBuilder for a couple weeks but I really like it so far.

I have found the problem by searching thru the forms. I cloned the form but had taken the easy way out and neglected to clone each form object and assign it to the new form. Once this was completed the form works properly with the WHERE statement included.

.