regnewby2465
Member
- Local time
- Today, 02:02
- Joined
- Sep 22, 2015
- Messages
- 58
I have a Main Form CAD_CallEntrySplitF which is bound to table ActivityT (which has ID as its primary key). There is another field in the same table called [ID_Activity]. I cannot rely just on the ID alone; I need the ID_Activity number archival purposes and related tables. I put
If IsNull ([ID_Activity]) Then
[ID_Activity] = [ID]
End If
In the BeforeEvent on the main form but it does nothing. I am assuming it is because the ID has not yet gotten its value until it is saved.
What should the syntax be and where should it go?
I need the value to show in the ID_Activity control on the form as soon as the event fires. Here are my current events on the form and some of its controls. Any help is appreciated.
Mark
If IsNull ([ID_Activity]) Then
[ID_Activity] = [ID]
End If
In the BeforeEvent on the main form but it does nothing. I am assuming it is because the ID has not yet gotten its value until it is saved.
What should the syntax be and where should it go?
I need the value to show in the ID_Activity control on the form as soon as the event fires. Here are my current events on the form and some of its controls. Any help is appreciated.
Mark