Link field

[Rkapoor via AccessMonster.com]

Hi all I am trying to creat a form where if i select the site name from the
combo box the address box is populated automaticaly from the master table

 

[Rkapoor via AccessMonster.com]

Forgot to mention i am using access 2003

Hi all I am trying to creat a form where if i select the site name from the
combo box the address box is populated automaticaly from the master table

 

[Douglas J. Steele]

Have the Row Source of the combo box contain both pieces of information
(whether or not you show the address when the combo's dropped down)

In the AfterUpdate event of the combo, put code like:

Private Sub MyComboBox_AfterUpdate()

Me.txtAddress = Me.MyComboBox.Column(2)

End Sub

This assumes that the address is in the third column of the combo box (the
Column collection starts numbering at 0)

 

[Rkapoor via AccessMonster.com]

this is what i entered in the code please help me if it is right

Private Sub Combo92_AfterUpdate()

SOW.Text90 = SOW.Combo92.Column(2)

End Sub

combo 92 = combo box
text 90= where i want the text to update
sow =form name

 

[Douglas J. Steele]

It should be Me., not SOW.

Me is a shorthand for referring to the current form.

If you want to use the form name, you must use Forms!SOW

 

[Rkapoor via AccessMonster.com]

Thanks for saving me lot of trouble all u guys

It should be Me., not SOW.

Me is a shorthand for referring to the current form.

If you want to use the form name, you must use Forms!SOW

this is what i entered in the code please help me if it is right

[quoted text clipped - 26 lines]