Subforms

  • Thread starter Thread starter Deb Zipski
  • Start date Start date
D

Deb Zipski

I have a form that users enter data into and it is then
stored in table1. I recently added 14 fields to this table
for users to enter newly requested data. I do not want to
add these fields onto the same form but if they need to
enter this new data I want the user to be able to pull up
another form and the record number to be in sync with the
first form. I tried placing a command button on the form
to bring up my new one which it does but the record number
defaults to one and the other form could be on any record
from 1-47,000. Can someone please walk me thru how to
accomplish this.

Thank you very much in advance I am just starting with
access.
Deb
 
Deb,
This might help - when you create the command button,
select "Open the form and find specific data to display".
It's an option in the command button wizard, and lets you
identify the key field that links the 2 forms together.
I'm using access 97, so not sure if things will be
identical.
 
Back
Top