Open Form

[Guest]

I have a series of forms that open for a user to complete various fields of
an incomplete record. (i.e. Time, Date) However, I do not want the form to
display if there the record is complete. Can I somehow say if the query
returns nothing, do not open the form?

 

[Guest]

Please show us the code you use to open the forms.

 

[Guest]

The following works when the user clicks a button. Each form has similar
code to open the next form and close the current. I was thinking if I could
somehow run the query and say if nothing returns open the next form, else do
the following, but not quite sure of the syntax.

Dim stAdmitDate As String
Dim stConcurren As String

stAdmitDate = "frmAdmitDate"
stConcurren = "frmConcurren"

DoCmd.OpenForm stAdmitDate
DoCmd.Close acForm, stConcurren

 

[Guest]

You could perhaps use the DLookup function to determine if the data exists.
Something like this:

If IsNull(DLookup("myFieldName", "myTableName", "MyFieldName = '" &
myLocalVariable & "'") ) Then
DoCmd.OpenForm stAdmitDate
Else
'Do something else
End If

Look in Access help for details about the DLookup function.

Barry

 

[Guest]

Worked GREAT....thank you!!!

You could perhaps use the DLookup function to determine if the data exists.
Something like this:

If IsNull(DLookup("myFieldName", "myTableName", "MyFieldName = '" &
myLocalVariable & "'") ) Then
DoCmd.OpenForm stAdmitDate
Else
'Do something else
End If

Look in Access help for details about the DLookup function.

Barry