Avatar of wlwebb
wlwebb
Flag for United States of America asked on

Access Subform Time textbox - send value to Main Form

I have a Form with a SubForm.  

The Subform has a Time Selector.  It is comprised of 4 unbound textboxes.  the first 3 textboxes the user clicks a control button that is is functioning as and up or a down to increment by 1

The 4th text box also unbound is where I take the input by the user and combine it to get the time value

That textbox is [tbTime] On subform [frm_DataDetail]

The code which on the textbox of the Subform works is:

=IIf(nz([tbHr],0)=0,"",IIf(nz([tbMin],0)=0,"",IIf(nz([tbAMPM],"")="","",(TimeSerial(IIf([tbAMPM]="AM",[tbHr],[tbHr]+12),[tbMin],0)))))

Now then I want to bring that time from the Subform over to the Main Form into another unbound textbox.

That Main Form's textbox is named [tbTimeInput]

I have keyed the following code which is not working.
=[frm_DataDetail].[Form]![tbTime]

All I Get is the #Name?

I have done the same Control Source formula to get data from a Subform to the Main Form for other numbers but since this is "Time" is there something else I must add?????

That textbox is formatted "Long Time"

That SubForm 4th Textbox is in the Footer if that makes any difference.
Microsoft Access

Avatar of undefined
Last Comment
wlwebb

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
IrogSinta

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
wlwebb

ASKER
Yep... deleted the Main Form textbox...didn't fix it...

Then I deleted the Subform and brought it back in.... that did the trick
Your help has saved me hundreds of hours of internet surfing.
fblack61