combo box won't accept values

Alaska Cowboy
Alaska Cowboy used Ask the Experts™
on
I created a combo box on a continuous form, used the wizard, etc. All looks good but it won't accept the value . . . this list pops up but you can't select one . . .

it's like it's not enabled for data entry, but when you select one, nothing happens.
enabled = yes
locked = no

and right beside is another combo box that DOES work, it was set up in the form wizard. I checked the properties and they look the same.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Seems you are trying to save wrong type of data from this combobox and it is bounded to table's field. Check field's type in table and bound column in combobox.
Hamed NasrRetired IT Professional
Commented:
Check the bound column propery value to reflect the index of the column.

Author

Commented:
apologize for the delay, will check tonight.
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Author

Commented:
Finally back, posting my system.

In the screen Candidates, I can select a record in the sub-form, but it's not carrying the id from the parent record. The records display properly but I can't add a new record. I have a Before-Insert expression on the sub-form but that doesn't seem to work.

On the Positions plus candidates screen, I re-built it with a subform based on a table and not a query, but still can't get the records to save.

I think my troubles stem from the fact that my tables use lookups and not raw data with foreign keys - in Access 2010 which I am just learning I couldn't find the "Table Design" thingy.

Click on the two red-bolded screens, neither one allows me to add a child record.
Candidates-EE.accdb
Hamed NasrRetired IT Professional

Commented:
Tables appear with  different icon. Click table and select design view.
Context menu (right click)  does not show Design view.

Appearance looks different from my access 2010. What issue are  you using?
Tell me what to do to get the required output

Author

Commented:
nhasr,

>>Tables appear with  different icon.
- different from what ?

>>Click table and select design view.
- the only view I have is datasheet view

>>What issue are  you using?
- Academic version, but I can't find "About" to see the version . . .

>>Tell me what to do to get the required output
- Well, I can't get the required output . . . that's why I'm here . . .

I can't get a subform to work, see original question.

Thank you.
I will be happy to take a look if you upload the database in mdb format.
Hamed NasrRetired IT Professional

Commented:
Table icon differs from my database using professional.
Some commands are not showing.
I could not follow the original question. What I need a step by step instruction, like:
1 open form ...
2 click button ....
3 enter 123 in field ID
..... so on
until we get to the required output.

Author

Commented:
vadimrapp1,  how do I save in .mdb format ?

hnasr,
- open Candidates form
- attempt to add a 2nd record in subform
    - error is "... cannot find record in table 'Contacts' with key matching field(s) 'Candidate'

- then open Position Candidates
- attempt to add a Candidate to position CEO
- error is "You can't assign a value to this object"
from http://office.microsoft.com/en-us/access-help/save-an-access-2010-database-in-an-earlier-file-format-HA010341553.aspx:

On the File tab, click Save & Publish.
Under Save Database As, do one of the following:

    To save a copy of the database in a format that can be opened by using Access 2002 or later, click Access 2002 - 2003 Database (*.mdb).

Click Save As.

Author

Commented:
vadimrapp1,

can't do it - it says "You cannot save this database in an earlier format, because it uses features that require the current format."

I guess because I bought an academic version I'm screwed . . . I can't see a table layout like normal in Oracle or something, only the datasheet view. So I have lookups in my table which I believe is not the way to go . . . but I can't see the design table so can't do it . . .
You were trying to save data to wrong tables. You should save data to "Position Candidates" table.
There is no difference between academic and retail versions, only licensing terms.
Candidates-EE.accdb

Author

Commented:
ok, I will check it out.

how come i cant see the design view for tables, only the datasheet view?

i will check your solution in a bit, thx

Author

Commented:
didn't get my question answered, will open another question and take a different approach.
You shouldn't accept answer if it is not answering your question, but it does.
As I can see in your next question you have problems with basic principles of data storage.
You are correct - try not to use lookup fields in tables until you will understand how data are really stored.

Author

Commented:
als315, yes, this was a bust question, I waded in too quick and pretty much was thrashing.

actually, I don't have problems with basic principles of data storage, I had problems with not understanding Access 2010, I used a web system as a template and didn't realize the limitations.

So I've started with a clean slate, designed the tables properly, and in one night did what I was trying to do for weeks but had been using the web stuff and getting twisted up like a pretzel.

I created the juntion table and now a subform, and it's working fine.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial