469,289 Members | 2,127 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,289 developers. It's quick & easy.

Text boxes populating from combo box

I have a form in MS Access 2007 with a combo box (Combo30) and two text box (ID & EntityType) populating from a combo box. When I select information on combo box both boxes get populated ok. However, when I select the following information, the new information replaces the old one.

'Find the record that matches the control.
'Update the row source of Text47 Textbox
'when the user makes a selection in Combo30
'combo box.

Private Sub Combo30_AfterUpdate()

If Not IsNull(Me!Combo30) Then

Me!Institution.Value = Me!Combo30.Column(0)
Me!ID.Value = Me!Combo30.Column(1)
Me!EntityType.Value = Me!Combo30.Column(4)

End If

End Sub

Also, when I come back to the form, the data is not saved.
I'm going crazy with this!! Can someone help?
Jul 18 '10 #1
2 1444
@Susy Fernandez

I've seen that 36 people have viewed my question. Please let me know if anybody can help...I need this answer by tonight. I'm trying to populate 2 text boxes from a combo box and the data is not saving. When I come back to the form, the data is gone. Also, when I select new data it replaces the old on ALL my entries. Please advise. Thanks!!
Jul 18 '10 #2
1,168 Expert 1GB
@Susy Fernandez
I imagine that your deadline has passed, which is unfortunate. You should have posted in the Microsft Access/VBA forum.
Jul 27 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Bill Brinkworth | last post: by
1 post views Thread by tomlebold | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.