• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 163
  • Last Modified:

Why sub-form (continuous form) doing this?

For the life of me I can't figure out why a continuous form sub-form is doing this.  Here is a screen shot of it...

subform
And here is a screen shot of the actual data...

table data
And here is my afterupdate (and oncurrent code)...

Private Sub cboMedID_AfterUpdate()
    
    Me.txtMedGenericName = Me.cboMedID.Column(2)

End Sub

Open in new window


I've done this countless times before but am perplexed!
0
SteveL13
Asked:
SteveL13
  • 2
1 Solution
 
pdebaetsCommented:
Try setting the control source of txtMedGenericName to

=cboMedID.Column(2)

... and remove your after update and on current code that sets the value of txtMedGenericName.
0
 
SteveL13Author Commented:
Perfect!  But I can't see why my way wasn't working.  It has in the past.  I must be missing something.
0
 
pdebaetsCommented:
Well, if you are setting the value of an unbound control on a continuous form, then all of the continuous form fields in that column get the value. When you bind the control, then it looks to the record related to the continuous form row. That's how I see it. Maybe others will have a better explanation of what is going on.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now