add a record in an autolookup query

[Guest]

I have a form based on an autolookup query. When I add my vendor number in a
field on the form, Access retrieves all the relevant data for that vendor and
lets me edit it. However, if the vendor does not exist, when I try creating a
new record for that new Vendor, it does not let me add that new record to my
file and spits out an error message. How can I get Access to let me do this?

Thanks

 

[Dale Fye]

Check the Forms AllowAdditions property (it's on the data tab) and make sure
it is set to Yes.

HTH
Dale