Hi,
I need help automatically populating a form from data stored in Access. The form needs to have specific fields that are updated from an Access database. I want to be able to enter a site number and have the subsequent list of information (approximately 35 pieces of data) populate. I DO NOT want to update the Access database via the form. The form is for quick viewing and documentation only, not data entry. Currently I've been doing this with VB in Access which exported the data to a Word Document which was then saved as a PDF. It seems easier and less troublesome to go directly to the PDF form, but I can't figure out how!
I have already connected my database to the form using OLEDB.
I don't want a dropdown list and I don't want buttons to scroll through the sites (I've already found out how to do that through this forum).
Any help would be very much appreciated!!
