subform question

[Ielamrani]

This sounds very simple but I am having trouble making it work.
I have a form (frmMain)with a subform in it. in the frmMain I have a text box called txtDate and another text box in the subform called txtCheckDt.
what I am trying to do is: whatever date is typed in txtCheckDt (in subform) should appear in txtDate (frmMain).

I tried this putting the following in Control source or Default value of txtDate but I get error #name?:

=[Forms]![TMarketingCall subform]![txtCheckDt]

 

[PHV]

Have a look here:

http://support.microsoft.com/?kbid=209099

Perhaps this ?
=Me![TMarketingCall subform].Form![txtCheckDt]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Ielamrani]

I am sorry I tried your suggestions =Me![TMarketingCall subform].Form![txtCheckDt] , no error message but still not working.
I can't access the site you recommended because they blocked it here at work. I'll try it when I go home.
Thanks
Ismail

 

[PHV]

no error message but still not working
So, what happens ?

You may try this in the AfterUpdate event procedure of the txtCheckDt control:
Me.Parent.Recalc

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Ielamrani]

Still nothing..text box just blank

 

[ssatech]

You could do this with unbound txtDate. With bound txtDate the record will not show up on your table. Unless someone out there knows of a way....

-In design view place an unbound text box at the bottom
your subform's form footer.
Make the Control Source..... =[txtCheckDt]and name it something. e.g. checkdate
-Then on your Main Form's txtDate
Make the Control Source...=[TMarketingCall subform].Form!checkdate

 

[TheAceMan1]

How are ya Ielamrani . . .

I have no problem with:

[blue]   =[[purple][b]TMarketingCall subform[/b][/purple]].Form![txtCheckDt][/blue]

[ol][li]Be sure to disable the code in the AfterUpdate event of [blue]txtDate[/blue].[/li]
[li]Double check the names/spelling.[/li]
[li]Is it your intent that [blue]txtDate[/blue] is unbound?[/li][/ol]

See Ya! . . . . . .

 

[Ielamrani]

Hi All,
I am sorry to reply late but I had no idea that you guys send me new solutions. Anyway, Good news. The last suggestions worked =[TMarketingCall subform].Form![txtCheckDt] Which means that PHV solution was good as well.
The Only change I did is: I put the code in the control source of the text box instead of After Update.

Thank you all for your help.

Ismail