By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,654 Members | 1,811 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,654 IT Pros & Developers. It's quick & easy.

Redundant amounts

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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

<br**********@hotmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
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.

Nov 13 '05 #2

P: n/a
<br**********@hotmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
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.

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
Nov 13 '05 #3

P: n/a
Thanks, I will give this a try.

Nov 13 '05 #4

P: n/a
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


<br**********@hotmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
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.

Nov 13 '05 #5

P: n/a

This worked out really well. Thanks for you help.

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.