If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Look for related record

I have th efollowing public sub used in a menu bar to open a form frmBudget. When this sub runs it opens the budget form and filters it based on the record that is currently displayed in the main form. My problem is that there are occasions when there is NO related record in the budget form and I get a parameter box asking for the Budget ID. How can I test for a related record?

CURRENT SUB:
Public Sub openBudget()
Dim frm As Form
Set frm = Screen.ActiveForm