Append from form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a large table of pupil details, each with a unique id number. This
feeds through to a number of other tables with differing additional
information. The user views this data through forms and it is necessary for
users to be able to archive pupils from any of these other forms.

Is it possible to write this into the form function in VBA as an afterupdate
command?

I am fairly new to VBA and am unsure as the the correct language

Thanks in advance!!
 
So what happens to a pupil record when it is archived?
How is it archived? (command button, automatic based on data values, etc)
Is it kept in the same table but filtered out with an Archive flag or moved
to an Archive table?

We need to know the above info to give a good answer.
 
when it is archived, the record remians in the main table, but is not shown
on the main form as is now 'is not null'

it is archived by picking an 'archive due to' option from a list box on the
form or table.

there is a seperate sub table 'archived pupils' which the id should be
appended to and is then date stamped.

i hope this makes sense, thank you for your time!!
 
I don't understand your first statment. What 'is not null' and how are you
filtering it?
Based on the rest of your post, I wonder if the secondary table is really
necessary. My approach would be to have 2 fields in the pupil table. A
Yes/No field that would be [ARCHIVED_FLAG] where No would be the default an
Yes would mean the student is archived. The other field would be the
date/time stamp of the archival. Then I would set the filter property of my
form to exclude archived records. Another advantage is you could add a
command button that would change the filter so you could see Not Archived,
Archived, or both.
To do the archival, I would suggest a command button that would update the
two fields.
 
thank you for all your help.

I have deleted the Archived table and added the additional fields to the
master table. I still need to be able to pick the reason for archive from a
list of values. I was therefore thinking of picking the value and then using
a command button to then add the date stamp to the 'date archived' field.

Is this the best way of doing this?

Thank you again
 
Back
Top