Automatically Updating a Field in A Form

  • Thread starter Thread starter Annie
  • Start date Start date
A

Annie

After_Update: After one field is updated via lookup, I
need it to fill the price field automatically. Sometimes
the code works and sometime it doesn't. Any suggestions??
i.e. After_Update
Me![Price]=Me![Item].Column(2)
 
Annie said:
After_Update: After one field is updated via lookup, I
need it to fill the price field automatically. Sometimes
the code works and sometime it doesn't. Any suggestions??
i.e. After_Update
Me![Price]=Me![Item].Column(2)
Click to expand...

What happens when it doesn't work?

Are you sure that all rows in your Combo *have* a value in column(2)?
 
Back
Top