Thanks a lot tekkyun. I was able to use the code you provided. I had some minor glitches but when I modified it a little it worked perfectly. This is what I changed:
Dim Frm As Form
'Dim sql As String
'sql = test_ea_apps
Set Frm = Forms(Test)
Frm.RecordSource = "qry-MSDN Applications"...
Would any of you gurus know how to change the record source of an Access dbase form on the fly? I have a standard form which is used to display records of 3 different types of software applications (Desktop, EA, MSDN). I would like to have 3 command buttons on the form each one programmed to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.