'Id' combo box carries all the entered values. Can you suggest me a way that whenever i select a value from Id combo, the rest of the entries of the selected combo Id value be displayed automatically in their respective fields.
And in case that id does not exist , it allows adding new data into the fields.
I started by implementing AfterUpdate() Event. but still thinking about how to move cursor to the record, filling 'in the respective fields, and simultaneously allow addition/update features in the same form.