Re: Two Questions on Forms for Access Database Project

To set a control in a form equal to a control in another form:

[Forms]![Form1]![Control] = [Forms]![Form2]![Control]

To base a form's data on the value of a control in another form, create a
query where the criteria for the field looks like:

[Forms]![Form1]![Control]

To find an unmatched record, create a query and use the Unmatched Query
wizard. Or simply create a query and add the main table (PIN #) and the
secondary table (PIN # assignments). Join the two fields using a one to many
join. Add the fields from both tables and for the secondary table's field,
use the criteria Is Null.


Sean Massey wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200611/1

.