Kostas Konstantinidis
kost36 at otenet.gr
Sun Apr 1 12:55:42 CDT 2007
hey group, I use the follown union SELECT [Title], [Year], [IDdirector], [IDcomposer] FROM [MT_basic_char] UNION ALL SELECT [title_collection], [year_collection], [IDdirector_collection], [IDcomposer_collection] FROM [RT_AM_COLLECTION_SUBFORM]; because of about 15000 records what I need to know is if there is a [Title] either in MT_basic_char or in RT_AM_COLLECTION I was wondering if it could be possible to make a button, when clicking to get back a searching form on that Union Query something like the default msaccess's Screen.PreviousControl.SetFocus DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70 but on that specific Union Query many thank's /kostas