Newbee needs help Combo Box access 2007

  • Thread starter Thread starter terry
  • Start date Start date
T

terry

I have a access 2000 project that would all me to create a combo box the
added the following code , so the values from the combo box would be stored
in the current form . also when typing the code below access 2000 would bring
up the code string

example when typing me.s it would bring up the value "shipper" from the
field list is this feature gone or just turned off on my copy

Example of code From Access 2000
Private Sub Combo 40_AfterUpdate(cancel As Integer)
me.shipper = me.combo40.Column(0)
me.Address = me.combo40.Column(1)

error

This error occurs when an event has failed to run because Microsoft Office
Access cannot evaluate the location of the logic for the event. For example,
if the OnOpen property of a form is set to =[Field], this error occurs
because Access expects a macro or event name to run when the event is fired.
 
If nothing else, the definition of the sub is incorrect. The AfterUpdate
event procedure does not support a parameter of Cancel As Integer.
 
Back
Top