Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Database II Access Project

Database II Access Project

Database II Access Project

We are creating an alumni database and have to archive some fields to another table.  I am trying an if statement to compare the address but have nothing to compare it to?  I am to append the address should it be changed, basically appending the original so on got focus the second time I should append then can change thereby saving my original data but how the heck can I do that?  Is an IF statement in the Address On change to do that or the LostFocus...Yes Ihave had VB and am in the second semester of Access...HELP!!!
Project is due in 1 1/2 weeks

RE: Database II Access Project

Your post is a somewhat garbled. If you want to keep both current and perevious addresses for your alumni, you have 2 choices that I can imagine:

1)  Use an Address table that contains the Alumni Primary Key as a Foreign Key and the date that that address becomes current and put all addresses in here.
2)  Have the current address only in the Alumni table and use the other table for previous addresses. If you intend to keep more than one previous address you would also need the date field.

It sounds as if you would not have a table of changes that you would update with a query; instead you'd be doing this operation one-by-one in data entry mode. I don't think, then, that you're actually wanting the OnChange Event, but the BeforeUpdate event instead, used with the control's associated OldValue (see Help if you're not familiar with these). You could use an append query that calls the form's Address table PK and the address field(s).

There are Access-specific forums at this site. If you'd like more help, please repost your question there. BTW, if you take a bit more trouble to phrase your question clearly you'll get a better response.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close