Even no Pop up coming. If you select the combo only the First column shows but the 2nd column which should be populate to Targeted text box were still blank.

There is still something off. It may be something other than the VBA code. Since I cant see your form I can't spot the issue.


If this were my project what I would do is create a new blank form. Create a new combo box and text box. See if you can make it work on this new test form.

Hopefully you have your database is split. This way you can link your test app (front end) to test data (back end).

If not split see: Splitting your Access database into application and data

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

Sir i made the new test one.

Tablename: TestTable
Fields: Properties, Rent, Targeted, Difference

Comboname: TestCombo
Fields: PropertyList, TargetedAmount

Where "Properties" Is a Combo box
Control Source- Properties
Row Source- SELECT [TestCombo].[ID], [TestCombo].[PropertyList], [TestCombo].[TargetedAmount] FROM TestCombo ORDER BY [PropertyList];
Bound Column- 2

Combobox After Update code
Private Sub txtProperties_AfterUpdate()
Me.txtTargeted = Me.txtProperties.Column(2)
End Sub

Sir IF BOUND COLUMN of Combo box is 0 or 1 the "PropertyList" was selected and goes to table but the value "Targeted" field are still blank.
IF BOUND COLUMN of Combo box is 2 and when i select the combo here is an error message "The value you entered is not valid for this field". Thanks sir i hope you can help me...

What is the Combo Box's Column Count set to?

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

Good Day,

Column Count - 3