Referencing a subforms controls based on recordset criteria

  • Thread starter Cyberwolf0000 via AccessMonster.com
  • Start date
C

Cyberwolf0000 via AccessMonster.com

I have a subforms that has 3 rows of 24 text boxes each. I am trying to
reference a specific control based on a field in the open recordset. I am
not sure where the issue is.

Any help would be appreciated. Here is the offending line. If more code is
needed please let me know.

Forms!frm_CalendarLV!frm_DayDetail.Controls("txtWeight" & Left(!ScheduleTime,
1)).Value = !TruckWeight

TIA,

--
James B Gaylord
For the Wolf comes the strength of the Pack,
For the Pack comes the strength of the Wolf,
-R. Kipling
Office 2003 on Win XP SP2
 
C

Cyberwolf0000 via AccessMonster.com

Never mind. I figured it out.
I have a subforms that has 3 rows of 24 text boxes each. I am trying to
reference a specific control based on a field in the open recordset. I am
not sure where the issue is.

Any help would be appreciated. Here is the offending line. If more code is
needed please let me know.

Forms!frm_CalendarLV!frm_DayDetail.Controls("txtWeight" & Left(!ScheduleTime,
1)).Value = !TruckWeight

TIA,
Click to expand...

--
James B Gaylord
For the Wolf comes the strength of the Pack,
For the Pack comes the strength of the Wolf,
-R. Kipling
Office 2003 on Win XP SP2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL UNION sorting issue 3
Subform Filter by Form not filtering when using Access built int Filter by Form 4
Main form not recognized in code line for subform control 2
Email sent using OIutlook 2007 from Acsess 2003 10
capture keypress on database open 4
Listcount from an ActiveX listbox 2
Form not recognizing record added via SQL statement 2
Form & subform Validation issue on Send Email button click 0

Top