Two Questions on Forms for Access Database Project

Tech-Archive recommends: Fix windows errors by optimizing your registry

Good Morning.

I just picked up a project building an Access Database for a real estate company to track the signs they hang in front of properties and the lockboxes they place on homes. I'm usually pretty good at building the database structure, but I am not very good at building and programming the UI.

I have two questions that I hope readers on this newsgroup can help me with.

The first question has to do with using multiple forms. I want to create a master form that allows the user to view active accounts. I want the user to be able to access the form to create work orders by clicking on a button, but I don't want them to have to re-enter account information when that new form opens. How do I pass data between the forms?

My second question has to do with creating new records. The real estate company usually tracks their active properties by the PIN number they're assigned. There is a limited number of PINs, and they are recycled. Is there a way to program the database so that when a new account is created, it will search the database to check to see if the PIN# is attached to an active property??

Thank you.

Sean
.

Quantcast