Help with Subform queries

[lmontes]

I have a subform based on a query. One of the fields needs to be formatted. I need this field to be updatable, but when I format it the way I want it (=[field]/60000), I'm not able to update the field later.

I tried adding a text box to allow for data entry and later copy that value to the field I want. When I put an unbound textbox, what ever value I enter in the box is carried to every record.

Is there a way to put an empty field in the subform and attach to that particular record?

 

[GingerR]

Hi there--you're not really 'formatting' the data, you're performing a calculation on it.

Why not just let the users enter the raw data, and wherever you need to display/use the calculated data in queries, forms and reports, just perform the calculation then? That's a typical scenario. Capture the raw data, and perform calculations later as necessary...

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244