Event trigger moving from one field to another references old data!

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

We've recently migrated from mdb to adp/sql server 2000.

We used to have events attached to combo boxes such that when an item
was chosen (update event), the event would cause another field in the
same record to be set (set value macro).

Specifically, when creating entries in an order details form, a user
chooses an item dropdown (referencing a catalog). Using a 'set value'
macro, the description and price from the catalog would be
automatically set for the remaining controls for that order detail
record. The user could then modify the description and price if
necessary.

Now that we've migrated to adp, the after update event triggers when
you move off the item number field, but the record had not yet been
saved, so it has no item to look up in the catalog table.

We've been able to get it to work with 'new' items by adding
RunCommand acCmdSaveRecord
prior to the set value macros. But this still doesn't work when you
alter an item number. It doesn't seem to do the 'set value'.

How do it get this to work with new items and changed items?

Thanks in advance.

Brian
 
Never mind. I was able to set the values for the other fields using
columns of the combo box field.
 
Back
Top