By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 3,102 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Form - Sub form

P: n/a
I have a table TBL_NAMES : IDNAME , Name_person , ETC..... (15
different labels)
I have a second table TBL_POINTS : IDPOINTS , LINKNAME_PERSON ,
POINTS_ALGEBRA , POINTS_GYM , etc.... (25 courses)

I have made a form where all the names are listed and when i click on
a name another form is opened with that persons name on top and a
number of labels and textboxes where i put those points in. So far
no problem. BUT... i want one record per person. So the next time i
click on his name i would like to see those points and be able to
change them but i must not be able to create a new record. That is my
problem : the second time i click on his name, i get a new record!!

The first time i made one table with everything in it and it was oke
until i began to count and made some calculations.

And yes, it must be done in access 97 not in Excel.

TX anyway, anyone, anywhere, anyhow, anytime
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.