Blank Field in form / Query

[Gregc]

Is it possible to have an unbound field on a continous subform that holds a value that will update another table. I have a form that has a quantity field and a ship Quantity field. I want the ship quantity field to be a blank field filled in by the user and then it updates a different table if they decide to continue, if not the value goes away when they close the form.

If I put an unbound field in a continuous form, the same number is put in the same field all the way down the form when I change the number. Is it possible to have an unbound field in a query that is not calculated?

Please respond if this makes no sense. Also, please respond if you have a solution.

Thanks in advance.

Greg

 

[SydneyGeek]

Greg, that's one of the major hassles with unbound controls. I usually use unbound controls for searching and in single-record views -- unless I want to assign the same value everywhere...

You could try binding the control to the Ship Qty field. Set the default value for that field (at the table level) to be blank (remove the 0 that normally is set for numeric data). Then the value in that field will be blank unless edited by the user. However, this can cause issues with trying to sum all shipped quantities. Much easier on the brain cells and hair follicles to keep 0 as the default, unless you have a compelling reason to do otherwise

HTH

Denis

 

[Gregc]

Thanks for the advice. I ended up going with my least favorite alternative, which was to have a shipped qty field in the table and setting it back to zero when the form is closed.

Greg