You are here:

Using MS Access/Reference to field on TabCtl and...

Advertisement


Question
Hi Scott,

I am quite familiar with referenccing a field on a subform for updating purposes.   However, not sure what the syntax would be to reference this...:)

Form [FrmProducts] has [CboStkCode[ and Tab Control [Tab1]
Tab1 has a subform [FrmSubProducts1] on page [ProductInfo]
FrmSubProducts has a field called [UnitPrice] which is what I want to update using code.   What on earth is the full reference to that field???   I want it to update on the AfterUpdate event of CboStkCode.

thanks in anticipation
Pete

Answer
Well first the Tab Control has no part in this. So the reference would simply be:

Forms!FRMProducts!FrmSubProducts1.Form.UnitPrice

Or simply:

Me.FrmSubsproducts1.Form.UnitPrice

Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Website: http://www.diamondassoc.com
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Scottgem

Expertise

I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.

Experience

I've been designing databases for over 25 years working with dBase, FoxPro, Approach and Access.

Organizations
Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing

Education/Credentials
Brooklyn College BA

©2016 About.com. All rights reserved.