Synchronizing forms still not working

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

Doreen

Hi all,
I re-posted this last week, and received a couple of
responses, but nothing that works. Does anyone else have
any ideas?

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!

I received the following responses:

Response #1: 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'.

Response #2: 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.

My Response to the answers: I have been choosing fields
from both tables. Relationships have already been set.
Neither of these are the issue. I NEVER get the window
asking about joining tables or linking forms. I am at
wit's end with this one!! This shouldn't be a show-
stopper, but it is turning out to be.

Thanks again in advance for any help that can be sent my
way.
 
Hi

U mentioned that both tables has the same Primarykey. I am
a little confused...what is the relationship between the
table...1 to one ? Did u add referential integrity?

Thanks
 
Yes, both have the same Primary key, which is the
scholarship account number. The relationship between the
tables is one to one, and referential integrity has been
set.
Thanks in advance for your help!
 
The wizard creates a link between forms either linked form
and subform or between two forms when the relationship is
one to many, when it's one to one I think one form is
created with all the specified fields from both tables...
 
Why do you have separate tables for the 'general' and 'account' information?
Can they not be in the same table?

[/QUOTE]
 
Another solution could be to create two forms. the first
form could have a button, clicking on which would open the
second form...
 
I used two tables because: a) the information from one
table will be updated from a program that is run nightly,
and b) the information for both tables are used for
different purposes and queries. The only time that the
information from both tables are needed at the same time
is when it is entered into the form.
If it doesn't make sense to do it that way, can you make a
suggestion for me?
Thanks!
 
That would be great! However, the Access documentation
that I have is very poor (it tells me I *can* do this, but
it doesn't tell me how). I've tried several ideas that
was found in the Help section, but again, there was not
enough information given to be successful. Could you help
out this amateur? :) Thanks!!
 
Doreen said:
I used two tables because: a) the information from one
table will be updated from a program that is run nightly,
Click to expand...

But that information can update some of the columns, by using a update
query. You don't have to update all the columns, so no need for a separate
table.
and b) the information for both tables are used for
different purposes and queries.
Click to expand...

Again, keep all the information in one table. Use queries to pull just the
fields and records you need for the purpose at hand.
 
Without having to recreate your tables like some other suggestions, here is
my idea.

1) Create 3 forms for accounting info, criteria, and renewal information.
Use the form wizrd for each if you like. Then edit each form to remove the
primary key field. Try to keep the physical size of each form fairly small.
2) Create a 4th form for General Info. Make this form fairly large and
move all your objects to the top left corner of the form.
3) Using the form design tool, add subforms to the form in step 2 for each
of the forms you created in step 1. Link the primary key from each subform
to the primary key of the general info table so that everything is linked to
each other.
4) Resize and move things around to make it look the way you want.

You should now have what looks like 1 form with 4 areas to enter
ifnormation. Since the other data is linked as a subform, adding new
general info data will automaitcally show blank entries in the other 3 areas
and adding data to any of the 3 areas will automatically enter the correct
primary key info into their corresponding tables. Good luck.

Kelvin Lu
 
Back
Top