Not quite sure what to do...

[kyle]

Ok, this is my first time even using access and im being asked to create an
easy to use data base for employee info. i think ive got a real good start,
but here is where im running into problems. So I have a Form to edit and add
employees but when i go to it, i get 4 pages each one shows same info which
is the first guy i typed into the tables just to get info started. I have 4
different entries but i am only seeing the same one over and over again. The
only thing i can think of is that i have two tables, education history and
employment history which are linked with a one to many relationship with my
main table. i think the issue is that these two tables are showing multi
entries for the same last name.
Also when i open my form it will not allow me to add new entries. however i
have my two history tables as sub forms to my main form and i can add new
entries to them. i have tried using the data tab on the properties of my main
form and allowing data entry but it still wount let me create new entries.
Thanks for anyimput you can give me on solving these problems!!

 

[mscertified]

what do you mean by 'i get 4 pages'? do you mean that when you press the
'forward' navigation button you see the same data 4 times?
what is the record source for the form?
to add new records you must have the 'allowadditions' property set to 'yes'.
Check the Data tab for the form.

Dorian

 

[kyle]

ah ok, i get 4 differernt records but all of them are of the same person
eventhough in my tables i have entered 4 different people. My data source was
set up by the wizard and i have already changed 'allowadditions' to 'yes'.
any other ideas or should i start over?

thanks

 

[mscertified]

So you are saying it is only one control on the form that is retaining its
data and the rest are changing for each record.
First make sure the data really is different in each table record.
Then look at the control on the form that is acting up.
Right-click and choose properties and look in 'control source'.

Dorian