copying a value from a form into a field in all records

[dome]

Hi,

How can I copy a value entered be the user into a field in all of the records of my table?

Thanks

Dome

 

[David R]

Why would all your records store the exact same value? Use a constant or an unbound text box on your form to 'show' the same thing without taking up the extra space.

Perhaps I'm misunderstanding what you want, can you be more specific?

David R

 

[dome]

Hi

Thanks for the response.

It's only for one field in the table

But I need to store the value.

Thanks

Dome

 

[David R]

OK, I'll need a clearer idea of what you're doing to help you.
Walk me through an explanation of what your user will do, and what the expected result is. Use plain English if you like, no need to try to work up pseudocode/table structure right now.

Post back and we'll see what we can do.
David R

 

[dome]

Thanks David,

I have a data base of different size pipes

Each record represents a pipe size
the fields in the record hold the linear footage of pipe that will be installed
at various depths

basically the database calculates the volume of earth removed from the ground

The dirt 'swells' after it is removed from the ground

This swell factor should be constant for each pipe at each depth; however, it isn't always.

I need the person to enter a swell percent and have that value placed in to the 'swellpercent' field of each/all record

I have a text box on the form for each record that alows you to change the value from record to record if needed,

I thougth I'd change that to a small pop-up form that gives you the option to apply that percentage to all record or just the record that the user is viewing on the form at that time.

I hope this isn't too confusing.

I know that it's a simple procedure, I just havn't been able to nail it yet.

Any thoughts are appreciated

Dome

 

[David R]

Still not sure you're using the right approach, but you can do what you ask with an Update Query. Be sure to account for whether you want ALL records to be updated, thereby wiping out existing values, or only records with null values, or only records with X as their value.

Play with it a few times in a copy of your database to get it to do what you like.

HTH,
David R