Having trouble automatically updating fields from one table to another

  • Thread starter Thread starter Sarah
  • Start date Start date
S

Sarah

I am very new/inexperienced with setting up Access
databases, so please be patient with me...

I am setting up a database to track zoning applications. I
have a form to be used to input the application
information, including an application number. I want to
add a control button on the primary form that opens a
second form that allows the user to input property id
numbers. When the property id numbers are entered, I would
like Access to automatically input the application number
from the primary form - which would still be open - into a
field on the sub-form (the property form).

I would really appreciate any ideas. Thanks a lot,
Sarah
 
Try this:

Say your original form is called frmAddAppl. You have
several fields, including one called APPNUMBER
 
Let's try this again:


Say your original form is called frmAddAppl. You have
several fields, including one named APPNUMBER which is
your application number. On this form you have a command
button that opens a second form called frmApplData. On
this form you also have a field named APPNUMBER. As long
as you leave the first form (frmAddAppl) open you can add
the following code to the second form's (frmApplData) load
event

Me.APPNUMBER = Forms!frmAddAppl.APPNUMBER

This will pass the application number from the first form
to the second. What you do with it from there is up to
you. I am assuming that you have a second table to store
the data (i.e. property ID numbers).

Let me know if this helps.

RW
 
Back
Top