Unanswered: How to Populate the Access Form Text Box With Combo box
Please let me help by the administrator or any other experiences person that how to populate my access form text box with the help of combo box.
i mean that when i pick a value from the combo box, all the correspondence data should be appear in the text field.
I have already try the following method but the result is nothing.
1.Open a table named "tableSource" with the fields of primary key,FirstName,LastName.And then filled it with necessary data.
2. Open a 2nd table named "tablemain" with the same field of above to receive the record from the form.
3. Make a One to One relation between these two table.
4.Open a new form on the basis of 2nd table and put a combo box with data from the source table.
5 . i click on the combo box event procedure and then click "on chage" and enter the code
All this procedure give me no result and my access form text field has not been populated.
Place a breakpoint on the first line of the procedure cmbx_AfterUpdate() and see what happens when you select a row in the combo.
i again thank you and sorry for my stupid question but i m novice in this field.So please don't mind about my boring questions.
I m a little confuse about the "breakpoint".
Will you explain a little more about the breakpoint i mean that what do u mean by a break point and where to palace it in my code.
I use exactly the following code for populating my text box with the help of combo box on the form.
Private Sub cmbx_AfterUpdate()
When i try to check my code,it work well.but when i close my form and reopen it.It fail to work and my text box show nothing according to the combo box.I also debug it but receive the same result.I have check everything one by one write the code again and again but still fail.I don't know where is the problem.Please give me every possible solution.
Could be a corrupted database.
- First make a backup of the database.
- Then, try to compact and repair.
- If it does not work, export the form in a text file:
1. Close the form.
2. Open a Standard Module.
3. Open the Immediate Window (CTRL+G) and type:
I have delete all the old files and create a totally new file for experiment only .It also gives the same issue.I mean the code work only first time.And when i close and reopen it the code did not work the second time.