Out of all the comments in your prior post his one stuck out the most:
And of course there were forms involve.
That's something a person who thinks Access is just "Excel With Forms" would say. And you're making other common mistakes they make in moving to Access--making tables out of queries, trying to update fields from other queries, creating temporary tables/deleting them/recreating them, etc.
Access is a database and it handles differently than a spreadsheet. If you get this "simple question" answered to your satisfaction, you're just going to return over and over with more "simple questions" because you've started down the wrong path for how databases are to work and built a poor foundation for your database.
Stick with this thread and someone might come along and help you solve this in the manner you want. But it won't be the manner in which it should be solved. I'll quit being a jackass now and drop out.