New record condition

[rosscortb]

Hi,



I have two tables, Personal Details and Address. I have one address into it currently, before a new address can be added the fields in the 1st address, Address End Date and Reason for leaving/Ending address must be added.

Do you know how I do this?

Cheers

Ross

[ranman256]

In the form,
in the ON CURRENT event, do a check
If end date and reason null, then
set the form DATAENTRY = false...or ADD RECORDS = false

[orange]

Ross.

Do you have some test data and a clear description of what you are trying to do?
Have you tried creating a data model of your proposed database and testing that model with your test data?
Have you identified some rules that your "business" must adhere to?

I don't think you have described your issue well enough to create a database. Getting a clear description of your business issue/opportunity and doing some "pencil and paper" conceptualizing can be a big help in designing your database.

[rosscortb]

In the form,
in the ON CURRENT event, do a check
If end date and reason null, then
set the form DATAENTRY = false...or ADD RECORDS = false

Hi

I'm struggling. Got as far as...


Private Sub Form_Current()
If IsNull(Me.Address_End_Date) And IsNull(Me.Reason_for_Leaving_Ending_Address) Then Me.NewRecord
= False

End If






End Sub

Ross