ID to display on access database form

[Emmanuel]

I have a database with table name : MEMEBERS with fields ID, FIRST_NAME & LAST_NAME.

I have a form with name ACFORM

I have a drop down field with name FULL_NAME which picks both first name and last name from MEMEBERS to be displayed together

My problem is, I want to create a new textbox to display the ID of the name selected.

For example, if John Smith has an ID of 10, once I select the John Smith from the drop down, the ID number which is 10 should appear in the new textbox automatically.

Is this possible is access database?
If so, how can that be done

[pbaldy]

See if this helps:

http://www.baldyweb.com/Autofill.htm

That assumes the ID is a field in the combo's row source.

[moke123]

I have a form with name ACFORM

Since acForm is an object type constant I would strongly recommend you choose another name.

[Emmanuel]

Since acForm is an object type constant I would strongly recommend you choose another name.

That’s not the real name
Am only using that to represent the name of the form

[Welshgasman]

So the table is not called memebers also? ��

[Emmanuel]

So the table is not called memebers also? ��

All other details are correct
It was only the form which I didn’t use the actual name

[Emmanuel]

See if this helps:

http://www.baldyweb.com/Autofill.htm

That assumes the ID is a field in the combo's row source.

I didn’t include the ID in the combo. Whenever I try to include the ID in the combo, the names are displayed together without any spacing.
Example: John Smith displays as JohnSmith

Will your suggestion still work?

[Emmanuel]

See if this helps:

http://www.baldyweb.com/Autofill.htm

That assumes the ID is a field in the combo's row source.

Also, in the code:
Me.TextboxName =. Me.ComboName.Column(2)

Coloumn seems not to work with the auto number ID field

[Emmanuel]

I didn’t include the ID in the combo. Whenever I try to include the ID in the combo, the names are displayed together without any spacing.
Example: John Smith displays as JohnSmith

Will your suggestion still work?

This has been fixed

[Emmanuel]

Also, in the code:
Me.TextboxName =. Me.ComboName.Column(2)

Coloumn seems not to work with the auto number ID field

Have been able to find a fix
Thank u all for your time