Recent content by jeni_ojeni

i have several tables and need information from each table BUT not all tables will have info. The problem is that it won't populate a response unless all criteria's apply. I think I need more like and/if in the criteria but not sure how to do that. I have the following tables: Drawing, data...

I've created a query and a report and a button to open the report. but not too sure how to get it to print what I chose from the main form. but i'm getting closer!

I'm sorry i am not sure which field you are talking about. I created the queary from the main and subform but i'm not sure what to do next. I know basic access but when it comes to coding and macros, i am lost. thanks

Thanks but the report opens all the information in subform and not what I picked from the combo box.

i am trying the exact thing as jacjacjac - where i print a report from a main and subform but i'm not sure how the code works. do i put brackets around it or put is like you have it. I put it like this but it has errors. Private Sub REPORT_Click() DoCmd.OpenReport(rptSPECS_PRINT1,[View As...