Can’t get my selected item in my select form that is in a combobox to show up in my edit form

[IamKJVonly]

I am trying to take a selection I click on in my combo box (list dropped down) and take the record ID and send it to my edit form so I can edit the whole selected record.

But when I click on a selection in the list I always get the same record to edit and it’s not the one I selected

The problem I think is than even though I have combobox show 2 columns (1=The item I want and the other is the record ID but when I click on the item I want it only shows that Item in the header of the combo it doesn’t show the record ID going with it.

Here is the code for then embedded recod for “Open form” click

Embedded macro code is: ( ==”[D_BookID]=” & [D_BookID] )



Any Idea what I’m doing wrong.

Any and all help will be apricated.

Dave

[mike60smart]

Best to upload the Db so we can see the structure.

[IamKJVonly]

I'm sorry. forget I ask. I can tell I'm way over my head. I tried to upload my file but this forum says it's to big and my zip program says it can't understand the file's format so I'm not going to spend money and time to try and learn more hoops to jump through to zip a file.

If someone can't tell me why the second column of a 2 column combo line is not actived when you click on it I'll just have to give up on combo and list boxes.

Any way thanks for listening to my rant,
I always seem to make things harder than they should be

Dave

[orange]

@Dave,

If you can't post a copy of the database, then send some screen captures of
-your table(s) design
-the form design including the properties of the combo

Readers need a little more info to offer focused advice/help.

FYI:
Combo columns start at 0
Some columns can be hidden (eg width = 0)

Most on the forum do NOT use macros.

I'm sorry. forget I ask. I can tell I'm way over my head.

With 28 posts, I'm sure someone here can help! Think positive.

[Gicu]

Check the values of the bound column for duplicates, please have a look at the similar post:
https://www.access-programmers.co.uk...ox-why.320867/

Cheers,

[IamKJVonly]

Thanks for all your help but after careful consideration I have come to the conclusion that I need more experience with Access 2010 before I can follow what you guys are telling me so I have decided to go in a different direction and NOT use a list bob or a combo box until I can get enough experience to use them correctly.

I want to thank everyone who tried to help me. I'm hoping that in the future I can come back to this post and understand what I'm doing wrong. I know I'm making things more complicated than they need to be.
Dave