Using a combo box on a form (1 Viewer)

P

PulseTeqUser

Registered User.

Local time

Today, 03:15

Joined

May 2, 2017

Messages

15

• May 15, 2017

• #1

I have a form for entering orders. There is a field which is for the supplier name. I have linked to the Suppliers table so as to get the list of suppliers but when I select one it does not populated the Supplier field on the Orders table. How can I get this to work?

Thank you

 

Ranman256

Well-known member

Local time

Yesterday, 22:15

Joined

Apr 9, 2015

Messages

4,339

• May 15, 2017

• #2

IF the combo box uses the NAME (and not ID) then,
The combo BOUND column must be set to name field column.
The target field where the data will be saved is CONTROL SOURCE.

 

P

PulseTeqUser

Registered User.

Local time

Today, 03:15

Joined

May 2, 2017

Messages

15

• May 17, 2017

• #3

Thank you for your help. I have got it working now.