Newbie Question

[Bob Guidice]

I'm trying to desing a database to track students at a school. One main
function that I'd like to have is this:

On the main data entry form, there will be subforms for attendance, test
scores, etc. I would like to be able to enter a Social Security Number, a
Last Name or a First Name at the top, and have the subforms populate with
the appropriate information.

Unfortunately, the problem I'm running into is because the Social Security
Number on the main form is the primary key, with which I'd like to enforce
referential integrity, I can only enter it once. Is there a way to get
around this, or is there another way to design this function in the
database.

I am pretty new to access, but once my tables are designed correctly, I'm ok
with queries and reports. I'm just having trouble with this function.

Thanks for any help,
Bob

 

[Brendan Reynolds \(MVP\)]

Don't tell my boss I helped you with this, because we sell the program you
just described, and he might not approve of my aiding a 'competitor'!

The problem is that you're trying to use a bound control (a control with the
name of a field as its Control Source property) for navigation. You need to
add another, unbound control (leave the Control Source property empty) for
navigation purposes.