combo box after update event

[james_halliwell]

Hi All,

I have created a form with a combo box which looks up my Returns_No

i want it to update the field below hows this done in the after update date

there are 3 colums

coments_If_required
Completed_Date
Complete_By

If someone could show me an example of the code put into vba it would help

 

[HAMMAMABUARQOUB]

this would be helpful...
http://www.access-programmers.co.uk/forums/showthread.php?t=176989
Filling and updating fields of a form based on a selction from a combo box
HAMMAM

 

[james_halliwell]

this would be helpful...
http://www.access-programmers.co.uk/forums/showthread.php?t=176989
Filling and updating fields of a form based on a selction from a combo box
HAMMAM

Hi

I entered the below code into VDB but it comes up with Compile error

Private Sub Combo1_AfterUpdate()
Me.Comments_if_required (1)
Me.Completed_Date (2)
Me.Complete_by (3)
End Sub

Any Clues

 

[Scooterbug]

you aren't referencing the columns from the combo box correctly. The correct syntax would be:

me.ComboBoxName.Column

Remember that the columns start at 0, so the first column is 0, second column is 1, etc.
Also, make sure that the row source for the combo box contains the data that you want. You dont have to display it, but they need to be included in the row source.

 

[james_halliwell]

you aren't referencing the columns from the combo box correctly. The correct syntax would be:

me.ComboBoxName.Column

Hi

I Have changed the code in vba but it still come up with a complie error (Method or data member not found)

Private Sub Combo8_AfterUpdate()
Me.Combo8.Cutomer_Service_Comments (0)
Me.Combo8.Completed_Date (1)
Me.Combo8.Complete_by (2)
End Sub

is there somthing im not doing right

 

[boblarson]

is there somthing im not doing right

Yes, it would be:

Private Sub Combo8_AfterUpdate()
Me.Customer_Service_Comments = Me.Combo8.Column(0)
Me.Completed_Date = Me.Combo8.Column (1)
Me.Complete_by = Me.Combo8.Column(2)
End Sub

But that is if the combo box has that information in those columns and your combo has the number of columns property set to 3.

 

[HAMMAMABUARQOUB]

sory, i thoughtputting the link would let you readcarfuly how the code should b writen and what the sysnax should be...
any way thank for larson & scootburg for their contribution