473,386 Members | 1,668 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

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)
Me.Refresh

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 1666
@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
TheServant
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

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

Similar topics

0
by: Jim | last post by:
Hi, there, I am a beginner on Access. I have been taking so long time to try to figure out his, but so far, no clues. I want to select 2 combo boxes and Access will automatically fill in...
4
by: godber | last post by:
I need to populate text boxes for instance with employee information using their unique employee works number selected from a combo box. Can anyone help, I am told thru visual basic this can be...
2
by: Bill Brinkworth | last post by:
in vb.net 2005, i would like to pull up a name from a database (customers) (i can do this already), then after a name is selected from a combox box, to populate the form's text boxes with with data...
1
by: tomlebold | last post by:
Should text boxes or combo boxes be renamed on bound forms? In other word should the Department Name property be the same as Control Source property? I never rename them, but my IT manager seems...
2
by: jw01 | last post by:
I have a form in which there is one combo box and three text boxes: Combo Box: -> Item A -> Item B -> Item C TextBox1: TextBox2: ...
6
by: zuchowra | last post by:
Hi everyone. I need help. I have a combo box in my form that i want to populate multiple text boxes after you select your selection in the combo box. Here is my set up. The Fields that need to be...
2
by: Dave | last post by:
I have 3 tables of information feeding into 4 combo boxes on my main form (DR Form). I have as many list boxes (acting as text boxes) as there are fields in each one of the 3 tables. Once...
1
by: djsmiler | last post by:
Hi All I am new to all this. I have a form which is pulling data from a table into a combo box. I am trying to get text boxes to show me the fields from the combo box. But not sure how to do...
1
by: gosens | last post by:
Hello, I am hoping some one could help me out with the code for this one. Basically what i am trying to do is for a simple cash register system give a person the ability to enter a barcode...
0
by: gosens | last post by:
Hello, I am hoping some one could help me out with the code for this one. Basically what i am trying to do is for a simple cash register system give a person the ability to enter a barcode...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.