Right now I have a form based on an autolookup query such that when I type in
my VendorID, it pulls out all the information automatically if the vendor
already exists. It also allows me to edit and save all the existing
information for that vendor which is perfect. However, in the form, when I
click on add a new record (little box with an arrown and star at the bottom
of the form),a new form comes up and I enter a VendorID number which doesn't
currently exist in the database, but it won't allow me to save/add that new
reord since it says it doesn't recognize the VendorID (obviously since it's
new). It displays an error message.

Is there any way for Access to let me add a new record in a form that is
based on an autolookup query?!

Thank you for any help.

Create a separate form for adding a new Vendor. You can put a command button on your existing form to open this form.

--
Joan Wild
Microsoft Access MVP
"arsenalattack007" <(E-Mail Removed)> wrote in message news:488FD8F4-5DBE-41E0-8F6A-(E-Mail Removed)...
> Right now I have a form based on an autolookup query such that when I type in
> my VendorID, it pulls out all the information automatically if the vendor
> already exists. It also allows me to edit and save all the existing
> information for that vendor which is perfect. However, in the form, when I
> click on add a new record (little box with an arrown and star at the bottom
> of the form),a new form comes up and I enter a VendorID number which doesn't
> currently exist in the database, but it won't allow me to save/add that new
> reord since it says it doesn't recognize the VendorID (obviously since it's
> new). It displays an error message.
>
> Is there any way for Access to let me add a new record in a form that is
> based on an autolookup query?!
>
> Thank you for any help.