I have created a form where agents go in and select a neighborhood from a combo box. (row source-query) They then procede to enter information on these neighborhoods into 4 subforms that I have bound w/ the record id number (autonumber).
My problem is that instead of going to a new record for each neighborhood, they are just selecting a new neighborhood from the combo box, thus "erasing" the information they just entered into the form. They are not understanding when they go back to look for the previous neighborhoods why they are not there in the form.
Is there anyway that I can make it so they can only select one neighborhood per record number? That way if they went to change the neighborhood before creating a new record it would prompt them with an error message.
Is this something that can be done on the after update property of the neighborhood combo box, and if so, how would I do that?
Any suggestions as to how I could possibly solve this problem would be greatly appreciated.
Thanks.
[This message has been edited by Jill (edited 07-07-2000).]
My problem is that instead of going to a new record for each neighborhood, they are just selecting a new neighborhood from the combo box, thus "erasing" the information they just entered into the form. They are not understanding when they go back to look for the previous neighborhoods why they are not there in the form.
Is there anyway that I can make it so they can only select one neighborhood per record number? That way if they went to change the neighborhood before creating a new record it would prompt them with an error message.
Is this something that can be done on the after update property of the neighborhood combo box, and if so, how would I do that?
Any suggestions as to how I could possibly solve this problem would be greatly appreciated.
Thanks.
[This message has been edited by Jill (edited 07-07-2000).]
