Hi
I am attaching the relevant portion of a database which i developed. this is the scenrio:
my computer purchaser wants to keep track of all his purchases, primarily computers.
the order form has more details that are not shown. basically, the order form has the details as assets. assets can be computers or something else (not yet determined maybe servers etc..). i have two computer description tables, one that stores a model template and one that will be get a the descriptions after the user chooses the model number. the user can then edit the description. (i did not add the description tables for other types of assets).
adding a computer by choosing a model number works fine. however, depending on where the user clicks next an error occurs. if the user clicks on another field other than model number after adding the model number an error occurs (picture attached). if the user clicks into the next entry or previous entry into the model number, the sub runs fine. whats going on??
please help.
thanks,
sam
I am attaching the relevant portion of a database which i developed. this is the scenrio:
my computer purchaser wants to keep track of all his purchases, primarily computers.
the order form has more details that are not shown. basically, the order form has the details as assets. assets can be computers or something else (not yet determined maybe servers etc..). i have two computer description tables, one that stores a model template and one that will be get a the descriptions after the user chooses the model number. the user can then edit the description. (i did not add the description tables for other types of assets).
adding a computer by choosing a model number works fine. however, depending on where the user clicks next an error occurs. if the user clicks on another field other than model number after adding the model number an error occurs (picture attached). if the user clicks into the next entry or previous entry into the model number, the sub runs fine. whats going on??
please help.
thanks,
sam
Attachments
Last edited: