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

Automatic update in form field

P: n/a
Hi,
I'm creating a form based on a table. This table has fields including
UniqueID (auto numbered and different for each entry), Track (3
different types), ClassYear (4 different years), and ModuleID.
Now this form takes in info from some fields (eg. track, gradyear),
and automatically updates others (i.e. ID and ModuleID). But I need to
find a way to update the ModuleID a certain way. Here's the deal.
There are many types of students. Those in track 1 in their second
year, those in track 2 in their first year, those in track 2 in their
second year... etc, etc. The ID field gives each entry (no matter
track or classyear) a unique ID, but for the ModuleID I only want
unique ID's with in a certain group. So for Track 1/Year 1 students
there will be module ID's 1,2,3,4... And for Track 1/Year 2 students
there will also be module ID's 1,2,3,4... but every entry has a
different UniqueID.

Example

UniqueID Track Year ModuleID
1 1 1 1
2 1 1 2
3 1 1 3
4 1 2 1
5 1 2 2
6 2 2 1
Now how do i get the ModuleID field to update automatically when
entering the data in the form. I did it using queries and an update
button, but it was really inefficient and was running like 4 different
queries each time you wanted to make one entry, which cant be good. So
I was wondering if there is some code that would make this possible.

Thank you so much.
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.