Customized MenuBar; However, FormOpen Shows All Records

[b31luv]

I have two (2) forms frmArea and frmEquipment. A ControlButton on frmArea opens frmEquipment based on the current record (or selected record) of frmArea. I decided I didn't want to have control buttons on my forms and decided to customize my menubar and toolbars. I found a really good thread from Neil in this forum that help me customize. The problem is that when I use the MenuBar to open frmEquipment the form opens showing all records. Is there a way to correct this and only have frmEquipment reflect information based on the selected record of frmArea?

I also tried inserting the name of the command button in as the name in the menu bar =OpenfrmEquipment and I still have the same problem.

Thanks

 

[b31luv]

I'm sorry, I added the =OpenfrmEquipment to the On Action in the properties and it tells me it can't find the function name. I figure I should make the sub global or public. Please advise how.

 

[TheAceMan1]

How are ya b31luv . . .

Just transfer the function to a [blue]module[/blue] in the [blue]modules window[/blue].

See Ya! . . . . . .

 

[b31luv]

AceMan1,

I transferred the function to a new module which I named global and it still tells me that the function name can't be found.

 

[b31luv]

It's finding my function now; but it is telling me that I have an invalid use of Me Keyword (Complie Error).

 

[TheAceMan1]

b31luv . . .

Post the function!

See Ya! . . . . . .

 

[PHV]

Just a guess:
Replace all occurrences of Me with Forms!frmArea

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886