Combo box

[Accessuser67]

I have 3 tables and want to use a form to enter data in one of the tables. In the form I want to have a combo box where I select a value and that value is linked to another value that I want to show in the form. How can I accomplish this.

regards,
ekmoorhead

[June7]

Not sure what you mean by 'linked to another value'. Maybe this is what you want: http://datapigtechnologies.com/flash...combobox2.html

[Accessuser67]

Your link shows a blank page.

regards,
ekmoorhead

[June7]

It should, after a few seconds, start a video tutorial. Here is the page with links to all DataPigTech's Access tutorials http://datapigtechnologies.com/AccessMain.htm

[Accessuser67]

Still cannot see your links. Waited for downloading and nothing. The links are not showing neither.

regards,
ekmoorhead

[June7]

First time ever someone had problems with those links. What browser are you using? Internet Explorer, Firefox, Chrome all work for me on those links. Can you try another computer? Even my old laptop opens those tutorials and I can hardly ever open web videos on this PC.

[Accessuser67]

First time ever someone had problems with those links. What browser are you using? Internet Explorer, Firefox, Chrome all work for me on those links. Can you try another computer? Even my old laptop opens those tutorials and I can hardly ever open web videos on this PC.

Thanks for the hint. It was that I didn't have Flash on the computer.

Regards,
Ekmoorhead

[Accessuser67]

It should, after a few seconds, start a video tutorial. Here is the page with links to all DataPigTech's Access tutorials http://datapigtechnologies.com/AccessMain.htm

Your video tutorials are great. However, what my question is: I have a combo box that is 2 col. Is there a way to show both values after I have selected a value from the combo box? Your tutorial shows how to change the value in the combo box, but what I want is to show the values after I have selected it.

Regards,
Ekmoorhead

[June7]

The value shown in the combobox is from the first column that is not set with 0 width. You can concatenate fields into a single column. Example

SELECT AcctNum, AcctNum & " : " & LastName & ", " & FirstName As AcctCust FROM tablename;

AcctNum would have ColumnWidth of 0 and is the BoundColumn so that it is the value saved to bound field (the ControlSource) but the concatenated value will display.

[Accessuser67]

How can I show "none" as the first lookup record in a drop down combo box? I have a category combo box that shows the category and aisle for an item. More specifically, I want to be able to select none when I cannot find a category in my lookup box.

please help.

regards.

[June7]

Depends on whether the field is a number or text type. Number type cannot save 'None'.


If text type, options:

1. 'None' is a record in a lookup table

2. set the combobox DefaultValue to None. When new record created the field will show None and save that unless user selects something or deletes the 'None'

3. A UNION query to 'create' a record in the combobox RowSource

[Accessuser67]

Depends on whether the field is a number or text type. Number type cannot save 'None'.


If text type, options:

1. 'None' is a record in a lookup table

2. set the combobox DefaultValue to None. When new record created the field will show None and save that unless user selects something or deletes the 'None'

3. A UNION query to 'create' a record in the combobox RowSource

Please advise What does number 3 mean?

regards.

[June7]

Example:

SELECT "None" As AcctNum, "No Customer Account" As AcctCust FROM tablename
UNION SELECT AcctNum, AcctNum & " : " & LastName & ", " & FirstName FROM tablename;

[Accessuser67]

Example:

SELECT "None" As AcctNum, "No Customer Account" As AcctCust FROM tablename
UNION SELECT AcctNum, AcctNum & " : " & LastName & ", " & FirstName FROM tablename;

Thanks have a happy new year.

regards,
ekmoorhead

[Accessuser67]

Thanks have a happy new year.

regards,
ekmoorhead

Actually, I tried your recommendation with the set default value to none and that didnt work.

please help.

regards.