Link field

  • Thread starter Rkapoor via AccessMonster.com
  • Start date
R

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
 
R

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
 
D

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)
 
R

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
 
D

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
 
R

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]
 
Top