Combo Box changing customer name to random number

DarkSmile

Board Regular
Joined
Feb 22, 2021
Messages
90
Office Version
  1. 365
Platform
  1. Windows
Hi,

I have a database named 'klanten' , in this database I store information about our clients.
I created a form above this database, in the wizard I selected:

1. Find a record on my form based on the value I selected in my combo box
2. Selected fields I selected Customer
1680240781560-png.88755


3. The dropdown now shows customer names, but when selecting a customer it gives the customer ID
1680240869156.png


4. So I changed in properties under data the control source to Customer

From:
1680240923228.png


To:
1680240946726.png


This now gives me the customer name, but here is my real issue, every time I select one client and going to another one, it changes there name to a random number:
How can I fix this?
issue access.png


Thank you
 

Attachments

  • 1680240781560.png
    1680240781560.png
    22.8 KB · Views: 34

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
For some reason, I deleted customer again, closed the database and now just works.....
 
Upvote 0
Solution

Forum statistics

Threads
1,214,812
Messages
6,121,702
Members
449,048
Latest member
81jamesacct

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top