form?

[NewStudent]

Hello,

Hope someone help it.

When I click buttom to link to other form, if the form is no data available, i want to show up a message box.

The things that I don't know where I should to write code.
For buttom "onclick" or the forms?

Rong

 

[JoeMiller]

In the OnClick event of the button perform an if/then and a DCount on the query/table supplying the data to your popup form.
[tt]
If DCount("[MyField]","MyTable","[Criteria]=[MyCriteria]&quot > 0 Then
DoCmd.OpenForm "MyForm"
Else
MsgBox "No records match!"
End If
[/tt]

HTH Joe Miller
joe.miller@flotech.net

 

[SIG357]

Public Sub Button_OnClick()
DoCmd.OpenForm "otherForm"
End Sub

'-----------otherForm-----------------
Public Sub Form_Load()
'check for data
'if no data
MsgBox "No Data"
'end if
End Sub

Hope that's what you're looking for

 

[NewStudent]

JoeMiller,SIG357,

Thank you very much for your kind help. I am realy new student about MS Access. I got it and please share my happiness with you. This is my first project for this summer course.

Thanks again and have a good weekend.

Rong