Search results

Hi, I'm sure I'm overthinking this so any guidance much appreciated! I have a continuous subform. Because the records are often many, the user needs to scroll down the page. How do I have a text box in each row that shows Record x of Total Records? I tried setting a text box control source =...

Ok, Things aren't going as I planned. I can create the query I want to show using something along the lines of SELECT DISTINCT MasterTable.* from MasterTable INNER JOIN ChildTable on LinkingID.... etc. This displays the data I want in the master table and subform table.....however, I had to...

Thanks for your help Uncle! your comments made me re-think how a subform works. Now, the approach I took is as you suggested, more or less ;) In the Parent Load event. I set the Parent record source to show only the parent records I want via an SQL statement. Then, from the same place, I set...

excellent. How exactly can I do that? ;)

Hi, I've spent countless hours trying to work this out and searching this forum so I hope this question hasn't been asked before! I have a form and a subform with a master/child relationship set based on the primary key of each underlying table. All good there. Now, I want to use VBA to...