Problem with combobox

[MikicaMika]

Okay, people, I need to create a certain from but I have no idea how to do it.

I have these two tables.

Table Worker:

ID, Name, Last Name, Gender, Office_ID. Id is a primary key.



Office:

ID, Name, Adress. ID is a primary key.

Relationship: Office_ID - ID

My task is this:

Create a form Office which contains all the columns from a table Office. Column ID must be replaces with a combo box. Values in combo box are chose wfrom a table Worker and this field must remember ID(Worker). The list in combo box must not show the primary key of a table Worker.

No idea how to do it. Please help.

[MikicaMika]

Anybody?

[Bob Fitz]

I think you should be able to do most of this using the wizard.

Use the wizard to create the form.
Delete the ID control on the form and create a combo box control with the wizard to replace it.

[MikicaMika]

I know, but the wizard is whats giving me the trouble.

Because once I select ID and let's say Gender, I hide ID and the only thing I can store in the field is the Gender. But ID must be stored but not shown in combo list. Tried fucking everything and it still wont run. It's so frustrating, I almost broke the laptop.

[Bob Fitz]

What are the current settings of the following properties of the combo box:

Control Source
Row Source
Column Count
Column Widths
Bound Column

[MikicaMika]

What are the current settings of the following properties of the combo box:

Control Source
Row Source
Column Count
Column Widths
Bound Column

Control Source: Worker
Row Source: SELECT Worker.ID, Worker.Gender FROM Worker;
Column Count: 2
Column Widths: 0";1"
Bound Column: 1

Sorry for taking your time Bob. :/

[Bob Fitz]

Try changing the Control Source property to ID

[MikicaMika]

Try changing the Control Source property to ID

Now it doesn't allow me to select anything in combobox. Oh God, I hate this.

Thank you anyway.

[Bob Fitz]

can you post a copy of your db

[MikicaMika]

can you post a copy of your db

I don't know how to do that.

[Bob Fitz]

To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window, click Go Advanced below the Quick Reply window.

[Bob Fitz]

Attached is an example of what I think you are trying to do