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...
And here is a screen shot of the actual data...
And here is my afterupdate (and oncurrent code)...
I've done this countless times before but am perplexed!
And here is a screen shot of the actual data...
And here is my afterupdate (and oncurrent code)...
Private Sub cboMedID_AfterUpdate()
Me.txtMedGenericName = Me.cboMedID.Column(2)
End SubI've done this countless times before but am perplexed!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER