Re: Find a row in a table from a form

Harper,
Why do you have different tables for this data? You should simply place a
couple of boolean fields in your student table that identify whether or not
the student is licensed or unlicensed and whether or not it is an active
(archived) student.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html



"Harper" <harperwork18@xxxxxxxxx> wrote in message
news:1150395999.754294.237510@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,
I am making a database where there is a form where the user can select
whether an education grad. student is unlicensed or licensed. Nearing
the end of the program, their status does change (we hope) from
unlicensed to licensed. Also, the student's status may change simply
because the user may have mistakenly assigned the wrong status.

I have table STUDENT, table LICENSED, table UNLICENSED, table
LICENSED_ARCHIVE, table UNLICENSED_ARCHIVE among others. In form
STUDENT_ENTRY, I have a combo box with "unlicensed," "licensed," and
"unknown" and text boxes, one of which is IDNo (their student id
number). The IDNo is the primary key through the tables.

When the user changes the combo box from one type of status to another
(excluding "unknown," for which nothing happens), I would like to have
access 1.) look up the IDNo field, 2.) Find that IDNo in the original
table, the table that corresponds to the status the student is being
switched from 3.) Copy that row into table LICENSED_ARCHIVE or
UNLICENSED_ARCHIVE as the case may be 4.) Delete said row from original
table.

I understand how to do an append query and delete query so I have 3.
and 4. covered. But I am stuck at 1. and 2. I do not know VBA so if
there is some kind of solution I can understand using expressions or
whatnot, I'd be grateful.

Thanks much,
Harper



.

Relevant Pages

  • Re: Find a row in a table from a form
    ... IDNo is the PK for Students and PK and FK for all of the rest. ... table that designates whether or not the student is licensed. ... UnlicensedStudents ... There are exams and licensing numbers attached to ...
    (microsoft.public.access.forms)
  • Re: Find a row in a table from a form
    ... Lynn Trapp wrote: ... There are exams and licensing numbers attached to ... there are exams attached to an unlicensed student. ... The IDNo is the primary key through the tables. ...
    (microsoft.public.access.forms)
  • Find a row in a table from a form
    ... I have table STUDENT, table LICENSED, table UNLICENSED, table ... The IDNo is the primary key through the tables. ... (excluding "unknown," for which nothing happens), I would like to have ... I understand how to do an append query and delete query so I have 3. ...
    (microsoft.public.access.forms)
  • Re: Find a row in a table from a form
    ... not in the record of each student who takes the exam. ... Further, if each student can take several exams, and each exam is taken by ... There are exams and licensing numbers attached to ... The IDNo is the primary key through the tables. ...
    (microsoft.public.access.forms)
  • Re: Find a row in a table from a form
    ... There are exams and licensing numbers attached to ... there are exams attached to an unlicensed student. ... Lynn Trapp wrote: ... The IDNo is the primary key through the tables. ...
    (microsoft.public.access.forms)
Loading