Can this be done?

[tammyt]

I have a form with the following fields:

Period|Course|C No|Teacher|New Per|New Course|New #|New Teacher|Copy|Update

The "Copy" and "Update" fields are yes/no checkboxes.

What I want to do:

When "Copy" is checked, Period, Course, C No, and Teacher field contents would copy to New Per, New Course, New # and New Teacher fields.

I think I need an if/then statement attached to the "After Update" in the Copy properties. I not sure how to word it to copy more than one fields.

--------------------------------

Next problem:

When the Update check box is checked, New Per, New Course, New # and New Teacher fields to be copied into the Period, Course, C No, and Teacher fields and the New Per, New Course, New # and New Teacher fields blank.

Again, I think this would be an if/then statement attached to the "After Update in the Update properties. But how to write it? I'm stumped.

HELP!!!!!!

 

[jfgambit]

Tammy:

Why are you duplicating data in your database?

Do the fields from the form come from two seperate tables. If so, there should be a unique ID that links them so that you are not duplicating data. Can you give some description about you table structures?

 

[tammyt]

jfgambit:

This is for a counselor in a school for schedule changes. She needs current scheduling information and fields for new schedule changes. Due to the nature of the school (self-paced), students can have multiple schedule changes each semester. The report that is generated to be sent to the administrative office needs to show both old and new schedules each time a change is made.

 

[jfgambit]

You can add the following to the After Update event of the checkboxes

If me.copy = True then
me.New_Per=me.Period
me.New_Course=me.Course
me.New_Course = me.C_No
me.New_Teacher = me.Teacher
Else
End if

Visa versa for the Update field.

But again, I mention that you should look at your table structure. if you are duplicating data, then you might want to look into re-evaluating the talbes and how they are joined

 

[tammyt]

Thanks for the help.

I've looked at this every which way and can't figure out any other way to do it that would meet their needs.