Access: Close a Form that is not the Active form

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,678
Can you close one form from another? I know you can close the form you're on by using DoCmd.Close , "". How do I close another form. I need to make sure its not open when I run code.

Thanks
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,137
Office Version
365
Platform
Windows
Try:
Code:
[COLOR=#000000][FONT=&quot]DoCmd.Close acForm, "[/FONT][/COLOR][COLOR=#ff0000][FONT=&quot][B]FormName[/B][/FONT][/COLOR][COLOR=#000000][FONT=&quot]"[/FONT][/COLOR]
and put the actual name of your form in the part in red.
 

Forum statistics

Threads
1,077,977
Messages
5,337,506
Members
399,153
Latest member
Tsmith25

Some videos you may like

This Week's Hot Topics

Top