?? on Opening a different form if no data exists on theoriginal one

[eliotchs]

Hi

Hopefully I'll explain this correctly...

I have a button on a form which opens a pop up form called episodenotes.
Episodenotes runs a query based the ID on the main form and displays the notes for that ID

If that ID does not have any notes or the query it runs = 0 I want to open a different form which will add notes..



Please let me know if this needs any clearification...

Thanks

[ItsMe]

Episodenotes runs a query based the ID

Can you show the code that does this?

[June7]

One form can probably serve both purposes.

If IsNull(DLookup("ID", "EpisodeNotes", "ID=" & Me.ID)) Then
DoCmd.OpenForm "EpisodeNotes", , , , acFormAdd, Me.ID
Else
DoCmd.OpenForm "EpisodeNotes", , , "ID=" & Me.ID
End If

[eliotchs]

Thanks you..

Since I don't know bettter ... lol and the add form is a bit different..

I used

If IsNull(DLookup("clino", "Episode", "ClINO = '" & strClientID & "'")) Then
DoCmd.OpenForm "EpisodeADD"
Else
DoCmd.OpenForm "EpisodeNotes"
End If

Thanks Again..