Rabu, 29 April 2020

[MSAccessProfessionals] Getting duplicate values in combo box

Hi,

Haven't used Access in ages so please forgive me for all the questions.

I created a very simple database with one table and one form which contains the following fields:
clientid, clientlname, clientfname, addr1, addr2, date.

I created a combobox on clientid however I am faced with duplicate values (clientid, clientlname, clientfname, addr1, addr2) when I click the combo box to select the client.  I would like to see 1 row per client.  For new records where the client already exist, the only field that would be updated is the 'date' field. I tried using 'Select Distinct' in the Row Source but it didn't help.  

Any assistance would be greatly appreciated.

Regards
Toukey
_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115481) | Reply To Group | Reply To Sender | Mute This Topic | New Topic

Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Tidak ada komentar:

Posting Komentar