Search results

I see said that blind man... I used [Sales Analysis]. It allowed to run the code only when the form was open (as it was mentioned before). And I received a blank window with just OK button on it. The form is actually a pivot table, and it should draw data from a table or a query. Why am I...

I have been using the MS Access sample database (Northwind). When I run msgbox(Forms![Form_Sales Analysis].recordsource) Access says that it can't find the form. For names without spaces the syntax above did not work either - I used msgbox(Form_Products.recordsource) to get the source info...

ME would not work in this statement msgbox(me.recordsource) when the form is open or in design view. Only have to indicate the name of the form to make it work. How do I refer to the form labeled Quarterly Orders (space in between)? Thanks again for assistance.

Thank you. Is msgbox(me.recordsource) for immediate window? It would not work until I changed me to specific Form name (msgbox(Form_Suppliers.recordsource)). Even if the form was open. I had however problems with entering form or report names that had spaces in their names.

Thanks a lot for the prompt response

Hello, My apologies for probably a very simple question. I inherited various queries and forms. I sometimes need to slightly modify a form but cannot identify the query (table) that this form was built upon. How do I go about determining this? Thanks in advance.