Message-ID:

Somebody's terminal is dropping bits. I found a pile of them over in the corner.

devel / comp.databases.ms-access / Field not visible in dropdown list for when typing Me (dot) in VBA

Field not visible in dropdown list for when typing Me (dot) in VBA

<1c4f8881-2b38-418c-9188-ac628b62a736n@googlegroups.com>

https://www.novabbs.com/devel/article-flat.php?id=458&group=comp.databases.ms-access#458

copy link Newsgroups: comp.databases.ms-access

X-Received: by 2002:a0c:fbc3:: with SMTP id n3mr17484529qvp.3.1626558949026;
Sat, 17 Jul 2021 14:55:49 -0700 (PDT)
X-Received: by 2002:a25:cec4:: with SMTP id x187mr21264825ybe.402.1626558948716;
Sat, 17 Jul 2021 14:55:48 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-access
Date: Sat, 17 Jul 2021 14:55:48 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=37.41.117.204; posting-account=5DXv0woAAADdzOKU-xv_SMHwIdvcMgxY
NNTP-Posting-Host: 37.41.117.204
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <1c4f8881-2b38-418c-9188-ac628b62a736n@googlegroups.com>
Subject: Field not visible in dropdown list for when typing Me (dot) in VBA
From: prakashw...@gmail.com (Prakash Wadhwani)
Injection-Date: Sat, 17 Jul 2021 21:55:49 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

by: Prakash Wadhwani - Sat, 17 Jul 2021 21:55 UTC

Hello All ... Greetings! Hope you all are keeping well.

I'm returning to Access after an almost 15 year hiatus having switched to a Musical career as a DJ... but now since the entertainment business is at a standstill I'm forced to fall back to older (forgotten) skills. Kindly bear with me.

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.le

On the last line 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.

Subject	Author
Field not visible in dropdown list for when typing Me (dot) in VBA	Prakash Wadhwani