Fields in tab order in form not in table used to drive form and not showing in form design mode

Question

I have MS Access 2013 and created a single entry accounting database for a small organization using “Desktop Business Account Ledger,” which I have modified a good bit. I still have the “Account transaction list” form, but I changed it and changed the        “Account Transactions” table that drives is.

I removed the field “Transaction Amount” from the “Account Transactions” table, however when I go to the design view for the form and go to Tab Order, I see the field “Transaction Amount” still listed there. I’ve looked all through the form in design view but don't see the “Transaction Amount” anywhere. 

My question –the “Transaction Amount” must still be hidden somewhere in the form - how do I find it?

Answer 1

The easiest solution would probably to use the DeleteControl method using VBA.  See https://msdn.microsoft.com/en-us/library/office/aa221186%28v=office.11%29.aspx?f=255&MSPPError=-2147217396

If you simply wanted to identify it, you could use VBA to change its background color to say vbyellow, or simply set is top and left properties to 0, etc.... Something to make it stand out.

---

Daniel Pineault, 2010-2016 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 2

Try DataBase Documenter under DataBase Tools and then do a word search in the text file generated.

---

Build a little, test a little