It looks like I figured out the cause, and it only sort of had to do
with the security prompts. Apparently, the second connection was
occuring before update was completing in the access database. The only
reason it would work when clicking the prompts was it allowed an extra
second or so for the upd...
I am currently working on a PO form for our company and have run into a
bit of a snag. I have one one database with two tables that populate a
list of vendors and a list of PO #'s.On the form is a Get PO button that
connects to the databse, gets the first available PO # that is
available, updates th...