Delete a selected DATA

[Tat86]

Hi guys,

I am a newbie with Access, learning on my own.
I am currently working on that one: See below attachment.

I have a few issues but I have one on which I've already spent 2 days and I do not know how to solve it.

MAIN PAGE -> _Main Menu

Add/Remove an User -> Analyst Details FORM
When I click on that button, an empty page opens ID: (NEW) -> Great

I can add a new user entering Full Name + BackOffice ID and click on "+"
However, when I click on the list, it does not select USER properly and when I click on " - / Delete User " it does not work.

Error MSG: You can't go to the specified record.

I think I have to link the LIST and USERS to the above fields (ID, Full Name and BackOfficeID) but I have no clue how. :banghead:

I am new - so do not hesitate to describe things for me

Thanks a LOT for your help guys.
Tat

 

[GinaWhipp]

Welcome to the Forum!

Hmm, seems you need to do a little reading on normalization...

Jeff Conrad's resources page...
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page...
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP)...
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials...
http://allenbrowne.com/links.html#Tutorials

UtterAccess Newcomer's Reading List
http://www.utteraccess.com/forum/Newcomer-s-Reading-List-t1998783.html
Help with Normalization
http://www.access-programmers.co.uk/forums/showpost.php?p=1146957&postcount=2

Sample data models...
http://www.databasedev.co.uk/table-of-contents.html
http://www.databaseanswers.org/data_models/

Naming Conventions…
http://www.access-diva.com/d1.html

Other helpful tips…

Setting up a Model Database
http://www.access-diva.com/d11.html

My Database Standards...
http://regina-whipp.com/blog/?p=102

Now, redo your tables and form your relationships. Then what you ask will be MUCH easier.