Redundant amounts

Hi, I have a form that has an amount paid, billed amount, and expense
amount field. All three of these fields always has the same value. In
order to minimize keystroks, I'm trying to input the value in one of
these three fields and have the other fields fill in automatically. I
know a way to do this at the form level, the problem is that only one
of the three fields are being populated at the table level for these
fields.

Thanks for any help you can offer.

re: Redundant amounts

If you have 3 fields in a table which 'always' have the same amount then you
have a problem with database design. Assuming that by 'always' you mean
absolutely without fail no exceptions.

Looking at the names of the fields you've given I'd be surprised if they
really are going to always be the same.

Mike

<brianaasmall@hotmail.com> wrote in message
news:1115644760.403121.101230@f14g2000cwb.googlegr oups.com...[color=blue]
> Hi, I have a form that has an amount paid, billed amount, and expense
> amount field. All three of these fields always has the same value. In
> order to minimize keystroks, I'm trying to input the value in one of
> these three fields and have the other fields fill in automatically. I
> know a way to do this at the form level, the problem is that only one
> of the three fields are being populated at the table level for these
> fields.
>
> Thanks for any help you can offer.
>[/color]

re: Redundant amounts

<brianaasmall@hotmail.com> wrote in message
news:1115644760.403121.101230@f14g2000cwb.googlegr oups.com...[color=blue]
> Hi, I have a form that has an amount paid, billed amount, and expense
> amount field. All three of these fields always has the same value. In
> order to minimize keystroks, I'm trying to input the value in one of
> these three fields and have the other fields fill in automatically. I
> know a way to do this at the form level, the problem is that only one
> of the three fields are being populated at the table level for these
> fields.
>
> Thanks for any help you can offer.
>[/color]
Well without going into the rights and wrongs of your design you'd need
something like this in the edited control's 'after update' event (remember,
your form has *controls* and not *fields* - I have assumed your controls are
text boxes):

Me.txtMyTextBox2 = Me.txtMyTextBox1
Me.txtMyTextBox3 = Me.txtMyTextBox1
Me.Refresh

txtMyTextBox1 is the name of the edited control.

HTH - Keith.
www.keithwilby.com

re: Redundant amounts

Thanks, I will give this a try.

re: Redundant amounts

Unfortunately, there are no 'events' associated with data-entry directly
into tables. Which is why you should force your users to use forms for data
entry. Sometimes you must implement user-level security to prevent direct
access to the tables.

Another alternative would be to create an update query that reads the table
record by record and updates any blank fields with the desired value. You
could then initiate this query from a form or an autoexec macro.

Fred




<brianaasmall@hotmail.com> wrote in message
news:1115644760.403121.101230@f14g2000cwb.googlegr oups.com...[color=blue]
> Hi, I have a form that has an amount paid, billed amount, and expense
> amount field. All three of these fields always has the same value. In
> order to minimize keystroks, I'm trying to input the value in one of
> these three fields and have the other fields fill in automatically. I
> know a way to do this at the form level, the problem is that only one
> of the three fields are being populated at the table level for these
> fields.
>
> Thanks for any help you can offer.
>[/color]

re: Redundant amounts

This worked out really well. Thanks for you help.