Sychronize two forms??

  • Thread starter Thread starter Doreen
  • Start date Start date
D

Doreen

I posted this originally a couple of days ago, but did not
receive any replies. I am behind on my deadlines, so any
help is very much appreciated!
Thanks!

I am using Access 2002, and my database has several
tables, including two that deal specifically with
scholarship information: Scholarship general and
Scholarship account. Both tables have the same primary
key, which is the scholarship account number. I am
working on the forms that will be used by the data entry
staff to enter information about new scholarships. I
would like the form or forms to include separate screens
for 1) general info 2) accounting info, 3) criteria, and
4) renewal information.

I would like to either: 1) create a form with 4 "pages" or
screens or, 2) make 4 forms and link them together so the
staff can move between forms

I have come across some instructions in Help
titled "Synchronize two forms by using the Form Wizard",
but it doesn't match what I see on screen.
It says to open Forms, click on NEW, and click on FORM
WIZARD in the NEW FORM dialog box. Then choose the fields
from the tables that you wish to use, and click NEXT. So
far so good.

Then it says that the second screen of the wizard will
give me an option of LINKED FORMS. However, I do not get
this screen. I am prompted to choose a layout, etc.

My question is, since the wizard does not work as
described, is there any other way to achieve the results I
want with the forms?

Thanks in advance for any assistance anyone can give me!
 
Doreen said:
I have come across some instructions in Help
titled "Synchronize two forms by using the Form Wizard",
but it doesn't match what I see on screen.
It says to open Forms, click on NEW, and click on FORM
WIZARD in the NEW FORM dialog box. Then choose the fields
from the tables that you wish to use, and click NEXT. So
far so good.
Click to expand...

No, don't click next. Read carefully all the information on the screen.
Once you choose the fields from the first table, you can then select a
second table, and its fields. If you have set up relationships among your
tables in the relationships window, then you will get the option for linked
forms after you click 'next'.
 
Actually in the step where you choose fields, it sounds
like you chose fields from only one table. When you're in
that window selecting fields, include fields from the other
table(s) and then when you click Next you will get a window
asking you what field you would like to join the two tables
on. I take it that would be the primary key you have in
common. Follow the rest of the steps and you will end up
with synchronized forms.

Another hint too, try using subforms or a tabcontrol
object. Both these have wizards too. I prefer subforms
over tabcontrols but they're kind of suited to different
situations. Make sure you have the toolbox toolbar checked
from the View pulldown menu. The subform button is the one
that shows the usual "form" icon and the tabcontrol is the
one that looks like a manila file folder.

GOOD LUCK!
 
Back
Top