Populating Values from one form to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please help!

I'm trying to get the value from one unbound calculated field in "Accounts
Receivable" form and populate it to another field in the "Order Entry" form.
Both of these forms have two different tables as its recordsource.

When entering a payment in the "Accounts Receivable" form, the amount is
sometimes over or under what the actual amount due is. For example: We get
a $25.00 payment from Customer A who's invoice amount is $20.00, thus a $5.00
credit which shows up as a negative number. Another scenario would be a
$25.00 payment for an invoice amount of $30.00, thus a $5.00 debit which
shows up as a positive number. And, of course, we do get payments for the
exact amount due.

When Customer A places another order, we want the credit or debit amount to
automatically pull up in it's respective field (Credit or Debit) in the
"Order Entry" form, so that the value in one of those fields will be included
in the "Amount Due" field. How can I make this work?

Thanks for any assistance,
Nyla
 
Hi, Nyla.
I'm trying to get the value from one unbound calculated field in "Accounts
Receivable" form and populate it to another field in the "Order Entry" form.
Click to expand...

If the unbound calculated control on the "Accounts Receivable" form were a
text box named txtBalance, then the following line in the Control Source
Property of the unbound control in the "Order Entry" form would work:

=[Forms]![Accounts Receivable]![txtBalance]

The caveat is that the "Accounts Receivable" form must be open and the
"Order Entry" form must be filtered on the record displayed in the "Accounts
Receivable" form. If any other records are available for the user to cycle
through on the "Order Entry" form, then all of them would show the balance
for the customer indicated on the "Accounts Receivable" form, which might not
be applicable.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.
 
thank you, Gunny. I'll try it.

'69 Camaro said:
Hi, Nyla.
I'm trying to get the value from one unbound calculated field in "Accounts
Receivable" form and populate it to another field in the "Order Entry" form.
Click to expand...

If the unbound calculated control on the "Accounts Receivable" form were a
text box named txtBalance, then the following line in the Control Source
Property of the unbound control in the "Order Entry" form would work:

=[Forms]![Accounts Receivable]![txtBalance]

The caveat is that the "Accounts Receivable" form must be open and the
"Order Entry" form must be filtered on the record displayed in the "Accounts
Receivable" form. If any other records are available for the user to cycle
through on the "Order Entry" form, then all of them would show the balance
for the customer indicated on the "Accounts Receivable" form, which might not
be applicable.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.


Nyla K said:
Please help!

I'm trying to get the value from one unbound calculated field in "Accounts
Receivable" form and populate it to another field in the "Order Entry" form.
Both of these forms have two different tables as its recordsource.

When entering a payment in the "Accounts Receivable" form, the amount is
sometimes over or under what the actual amount due is. For example: We get
a $25.00 payment from Customer A who's invoice amount is $20.00, thus a $5.00
credit which shows up as a negative number. Another scenario would be a
$25.00 payment for an invoice amount of $30.00, thus a $5.00 debit which
shows up as a positive number. And, of course, we do get payments for the
exact amount due.

When Customer A places another order, we want the credit or debit amount to
automatically pull up in it's respective field (Credit or Debit) in the
"Order Entry" form, so that the value in one of those fields will be included
in the "Amount Due" field. How can I make this work?

Thanks for any assistance,
Nyla
Click to expand...
Click to expand...
 
Back
Top