I have a problem, Houston

[Lou_Reed]

When creating a combo box using the wizard several question arise:



In the window, it asks questions about retaining the input value

1. Remember the value for later use;

2. Store that value in this field: (then it give a combo box of its own choices from the record source table)

It gives you a choice and it does not let decline to put in a value. You must put in a value : either one of the two offered.



Also, when using the combo box wizard doesn't each combo box have a control source?

Any help appreciated. Thanks in advance.

Respectfully,


Lou Reed

[ranman256]

yes, the RowSource is the query from where to get the choices.

the bound column , tells which item in the list gets stored in the record field, once chosen.

[pbaldy]

Option 1 leaves the combo unbound (no control source).

In the future, a descriptive thread title is more useful to people searching for solutions.

[Lou_Reed]

Okay, sorry if my thread title put you off.

Again, when I am done with the combo box wizard do I go into the design view, and bring up info and give it
a control source? I did that once and it did not work. The SQL code spilled out and no choices when the combo box
arrow was clicked.


Respectfully,


Lou Reed

[pbaldy]

Okay, sorry if my thread title put you off.

It didn't "put me off", it was kind of funny. I'm a moderator and I'm trying to benefit all users. Right below where you entered that title was the text "Please use a meaningful and specific title to describe your question". That text is there because a meaningful title helps other members when they're searching for answers to their questions. If memory serves, it also helps the search engine indexing.

[June7]

ControlSource is necessary if you want to save the value into record. If the user input/selection is for filter criteria then the combobox would not have ControlSource set. So what is the intended purpose of the combobox - data entry/edit or filter input?

Really don't understand what the issue is. What does 'SQL code spilled out' mean?

[Lou_Reed]

I resubmit the last question again. I am not sure if you saw it. When I click finish in the Combo Box Wizard, am I done. Do I still have to give the combo box a control source?

Again, when I done with the combo box wizard do I go into the design view, and bring up info and give it
a control source? I did that once and it did not work. The SQL code spilled out and no choices when the combo box
arrow was clicked.

Any help appreciated. Thanks in advance.


Respectfully,

Lou Reed

[June7]

I saw the info in earlier post and my comments/questions are same.

[Lou_Reed]

When I said SQL code spilled out, I mean when the list dropped down instead of the choices that I expected say (Room No. in the example) all I got was SQL code.

I can compact and post it to show you what I mean. I think in a compact state it is less than stated limit.


Respectfully,


Lou Reed

[June7]

Sure, provide db. Or an image of the combobox property settings. Or just list them here.

RowSource
RowSourceType
ControlSource
BoundColumn
ColumnCount
ColumnWidths

This appears to be same issue in other thread https://www.accessforums.net/access/...ton-55203.html which you said was resolved.

[Lou_Reed]

I did at the time think that it was solved.

I was mistaken.

I think that when putting in a combo box that and even typing in the values for the drop down list. That one should not put in combo box control source.

BTW, I have a transcription error in one of my lists -Customer ID. One of the customer account numbers was put in incorrectly.

I could delete the Combo box and its label and reenter everything, but surely there must be a easier way to correct
just that one number and leave all the others unchanged.

If there is a way, what is it?

Thanks in advance. Any help appreciated.

I will put the database up if it is not too big for the forum.

Respectfully,


Lou Reed

[Lou_Reed]

My db is 588 kb and that is too big for the forum. I think that the limit is 500kbs.
What alternatives do I have? I can email it.

R,

Lou Reed

[Lou_Reed]

Ceil Inn_post.accdb

Here is my file. I had to delete several tables (customers, employees and rooms to get it below 500kb. I hope I did not delete anything important to the posed question.

As you can see now on the Comb Box Box in the Occupancies Form all is not correct. Please tell me what I did incorrectly.

Thanks in advance.

Respectfully,


Lou Reed

[June7]

Next time, zip the file with Windows compression - 2MB zip allowed.

The 3 comboboxes use ValueList, not SQL statement. They are working as set. Except ControlSource is not set. Select the field you want to bind to.

[Lou_Reed]

Ceil Inn1.zip

Okay, now here is the complete file. The three problem controls EmployeeID, CustomerID and RoomID. Each have a

control selected outside of the combo box. I pressed F4 and selected control for each one in the usual way.

When I go to form view and click on the down arrow of any of the three, I get some kind of code. It may not be SQL, but it looks like it.

That is not what I want. I want the choices. Say, when I click on the combo box for RoomID, I want the room numbers to appear in a drop down list.

They do not. What is wrong. Please note that you have the complete file now.

R,

Lou Reed