Search results

Hi How do I just print the active record to a report? It is not a continous form. I have but a report button on a form but when I run it, it shows all records, one on each page. I just want the active one only. I may also be adding a macro inbetween the form and the report to gather some...

Hi I have 1 table (Sales) being displayed by 2 Forms (Customer Sales & Customer Sales Other). 1 form (customer sales) is embedded in as a subform in a form called Photos, and the other is embedded as a subform in a form called Customers. From the Customers Form I create a report using a query...

How do I create a Form Filter based on list option? Can I create a macro to apply a form filter using a value from a selection list. IE, instead of applying a filter to a form were the Category field = One, can the filter start to run and return a list One, Two, Three, so I can then select Two...

How do I hide a field by default then display it based on a checkbox being clicked? Thanks!

In case my other question cant be resolved, I'd like to do a work around, but dont know how to do that either. So, I have a form (Photos) with a field (PhotoTitle) and in the form is a subform containing a continuous form a (Sales). This form contains invoiceno, location, customer etc... but...

Hi Not sure if anyone can help. Its been about 10years since I've built a relational access database, but offered to build one for someone, but am now a little stuck. Its a photo sales tracking db. I have 3 main tables. Photos, Sales & Customers. The main form is a photo form with embedded...