This is more of two questions. But my major problem is that I get the query is too complex error when I load up the form where this query is stored as a subform.
If I take out this part it works but I need something like this:
(Mid([combined_x_x]![nxx x...
I have two tables.
The main table contains a bunch of orders that different reps will need to work on. These orders will be assigned to the reps from a supervisor.
The main thing I would like to do is have a subform that displays all the orders in datasheet form. Then on the main form have a...
I have a subform as a datasheet. I want to make it so I can select items in that datasheet and click a command button on the main form to add those records to another table.
What would be the easiest way to do this?
I am using access 2007
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.