Recent content by theclosh

Thank you for the input. By Global variables, though, are you referring to using Me.Client_ID in the Query rather than Form!...?

I need a way to override the query setup for a form (frm1) using VBA. The query has criteria that is based solely on a separate form (frm2). I now need to be able to open the same form (frm1) but using criteria from another form (frm3). I'm trying the following DoCmd.OpenForm...

I have a couple of data access pages that are used for work and have worked just fine in the past. Recently the pages have been appearing for a few people but with no database information available (blank except for header info). In the past when this happened we were able to fix it by putting...

You probably already have your answer or gave up but it sounds like a primary key issue - you need one. Apply a primary key and it should fix the issue.

Not sure if this is the right place to put this (please tell me if it isn't). I am trying to create a page that lists client IDs in columns on a data access page. I have made it list out all the clients vertically regardless of the number of IDs but I can find zero documentation on how I could...