Record Check on Form OnLoad

[tramp82]

Hi! Hopefully someone can help me here.

I have a form "Customers" with a command button which opens up another form "Customer_Orders". The form that opens up is a list of orders in a recordset which the customer has placed and all can be viewed by using the navigation buttons.

Ok, so what I want is for the form to check to see if there are any orders placed . And if there aren't then we want a message to pop up straight away saying "No orders".
No matter what I try I can't get this to auto happen, even though I can get it to work with an extra command button.

Can anyone help? I've tried on form load, form open, form activate the lot.



Thanks,

Richard!

[pbaldy]

What code do you use behind the button? I'd expect either the load or current events to work.

[tramp82]

I got this for example (But I have tried .value = "", .text = "" etc)

If IsNull(Me.Invoice_No) Then
MsgBox ("No Orders")
End If

The form is called using an Access 2003 command button wizard if that makes a difference? I have posted it without the functions below if it has any relevance:

Sub ToggleLink_Click()
On Error GoTo ToggleLink_Click_Err

If ChildFormIsOpen() Then
CloseChildForm
Else
OpenChildForm
FilterChildForm
End If

ToggleLink_Click_Exit:
Exit Sub

ToggleLink_Click_Err:
MsgBox Error$
Resume ToggleLink_Click_Exit

End Sub

[tramp82]

Anyone got any clue on this?

I think it is POSSIBLY because the form is onload, does that load before the recordset and that's why it's not registering?

[pbaldy]

Did you try the current event? The load event should work, as the data should be there. The open event is too early. Are you sure the field is Null?

[tramp82]

Thank youuuuuu!!!! It works on the Form Current! Haven't ever used that before, but I still don't know why it doesn't work on FORM LOAD as I can see this is gonna be a problem for me in the future!?

Thank you so much pb

[pbaldy]

Happy to help. I would have thought it would work in the load event; perhaps something else is going on.

[tramp82]

I'm not too amazing on this but I have noticed that it works when switching from design mode to the live mode. But not when I totally close and then Open?

Is this something where the open event runs before a recordset is loaded? Or.... If so is there some way to get around it?

[pbaldy]

The open event runs before the load event, and doesn't have data. Can you post a sample of the failing db here?

[Paula]

Hi PBaldy,

I am trying to help my niece with her SBA assignment but not sure if I am doing it right I have created the 3 tables personal, constituency and name&acronym but I am having problems importing the tables. Can you help? Would really appreciate it as it would make me look good

http://wikieducator.org/images/1/1a/...abus_final.pdf

[pbaldy]

Paula, you should really start a new thread with your question. It isn't related to the topic of this one.