Search results

Hi I want to save an open form as a data access page. Is there any code to do this and bring me directly to the file location dialog or do I have to use the DoCmd.RunCommand acCmdSaveAs command and then choose data access page from the dialog box? Also, is there a way of saving a form as a...

OK Thanks!

Thanks Bob & Dennis Got it working. I need another bit of help. After I have changed the data source as above, I want to save the "template" form as a data access page. Is there any code to do this and bring me directly to the file location dialog or do I have to use the DoCmd.RunCommand...

Hi I am trying to change the data source of a form via code. The form I which to change is called "template" and the query name I wish to change the data source to is the same as the value in a field in a visible form i.e. Forms![frm Recs tracked jobs]![Job]. (A query of that name was created...