Populate subform field from main form field

[devastator442]

Hello,

I have an OrderDate date field on my main form. I have a subform linked to
it that has a column called TransactionDate. I want to put the OrderDate
from the main form and place it into the TransactionDate field on the
subform. I know how to populate data from the subform to the main form, but
I am having problems doing the reverse. Thanks!

 

['69 Camaro]

Hi.

I want to put the OrderDate
from the main form and place it into the TransactionDate field on the
subform.

Try:

Me!subTransactions.Form.txtTransactionDate.Value = Me!txtOrderDate.Value

.... where subTransactions is the name of the subform control (not name of
the subform itself), txtTransactionDate is the name of the text box on the
subform bound to the TransactionDate field, txtOrderDate is the name of the
text box on the main form bound to the OrderDate field.

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.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. 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.