Form Display Question

[Juan4412]

I have created a form based off a table. My table holds a numeric value for the salesperson, so we have tableSales which ahs the numeric value and atbleSalesPerson who has the numeric value and the name.



For doing data entry, I would like the user to be able to select the Sales Person Name from a combo box and it save the numeric value in tableSales

How do this?

[mike60smart]

Can you upload the database?

[Welshgasman]

Hardly need to upload a db for this?
Use the combo wizard.

[Juan4412]

Hardly need to upload a db for this?
Use the combo wizard.

How do I use the combo wizard to achieve this?

[mike60smart]

In The Design of the Form you would delete the current Control SalesPerson.

You then use the Combobox Wizard to create a Combobox that Looks up the SalesPerson table.

The last Step of using the Wizard is the would select Store This vale in SalesPersonID

[Bob Fitz]

How do I use the combo wizard to achieve this?

This may be of help: https://www.youtube.com/watch?v=5kxgvMW0FoU
but don't be tempted into having a lookup field in your table.
If you really can't manage to do this then you'll need to post a copy of the db.

[Gicu]

Open existing form in design view, right click the textbox bound to the SalesPersonID field and click on Change To and select Combo Box. Now click the Data tab on the Properties window for the combo and in the row source type select Table\Query and for the row source click the builder on the right and bring your tblSalesPerson table. Select the id and name fields, set your order and save. The final step is to set up the combo's columns: make column 1 the bound column, set column number to 2 and column widths to 0";3" (set also the list width to 3" or whatever you need to display the full names).

Cheers,