Can anyone help, I have a form where the primary key is an ID number. The ID number is the first field to be entered on the form. I would like the user to know if that particular ID is already entered before they go through and fill in the rest of the fields in the form. I've been trying to do this with the Validation property but I'm not sure how to specify "not equal to anything that has been used before".
I'd also like to know if there is a way to update a form so that it can pick up new values entered into a combo box (via a table) without closing and re-opening the form.
Thanks,
Andrea
I'd also like to know if there is a way to update a form so that it can pick up new values entered into a combo box (via a table) without closing and re-opening the form.
Thanks,
Andrea