I'm using Access 2003. Building on a very old software of mine with an old client, so have to stick to 2003.
I have a table "Inv_Table" that's bound to a form named "Invoicing".
In the "Activate" subroutine of the form I have the following code ...
Me.txt_Bank = Me.Bank
Me.txt_Branch = Me.Bank_Branch
Me.txt_Account_No = Me.Account_No
'Me.txt_Lease_No = Me.Lease_No
On the last line (above) Me.Lease_No is the name of my field and should be visible in the dropdown when I type Me (dot). Somehow it's not visible. I tried changing the field name to Lease_Num in the table just to check if it becomes visible in the form but to no avail.
I had a similar problem a few days back with the field name "Bank_Branch" above. I had used just "Branch" as the original name but it didn't drop down. Somehow when I changed the name to "Bank_Branch" it suddenly became visible. It's mystifying as none of these are reserved words.
I'd appreciate some help.