My combobox doesn´t update the selected value when I click on next record

[jplecaros]

Hi, I have a table called Proyects. This table has an Id, name, and year.
I made a form with the third option of the combobox wizard, for searching a record. So when I select a record throw the combobox, it displays all the info about that record. Until here, everything's ok.

The problem is that when I click on next record (little arrow on the lower section of the Access screen, near the search box), the combo box doesn't select the new record.

Aditional info:
The form has 2 fields selected on Row Source: Id and name
Control source is empty

If I set the name field on control source, the names of the combo box star to change to the id numbers as I select them on the combobox. So after clicking on all the names of my combobox, my combobox displays only id numbers and not names.

If I set the id field on the control source, I can´t select the records on the combobox, due Id is a primary key.

I haven´t found any answer on the Internet
What can I do, please help me.

[RuralGuy]

It all has to do with whether the ComboBox is bound or not. In order to use the cbo to look up records (by selecting #3 from the wizard) the cbo *cannot* be bound. In order for an unbound control to display data from a field in the RecordSource of the form, you need to take extra steps. You could use the CurrentEvent of the form to set the cbo to display what you want.

[jplecaros]

Thanks a lot for your help, the problem is I'm too new like for writting down such code.

What could be an example of that code?? Sorry for stealing your time, thanks a lot!


Private Sub Form_Current()

End Sub

[RuralGuy]

What do you want the cbo to display? What is the RowSource of the cbo and to what is the Widths property set?

[jplecaros]

I need to display the name of the Proyects

The row source is the Id of the proyects, and the name of the proyects, but I hide the first column, so I only see the name of the proyects on the cbo.

The exact row source is in spanish and it is:

SELECT [Proyectos].[Id], [Proyectos].[Nombre (Ciudad y Calle)] FROM Proyectos;

[RuralGuy]

Does the RecordSource of the form contain this field and if so what is the name of the field? [Proyects] perhaps?

[jplecaros]

It's [Proyectos], which means [Proyects]

[RuralGuy]

Okay, try something like:

Private Sub Form_Current()
   Me.ComboBoxName = [Proyectos]
End Sub

...using *your* ComboBoxName of course.

[jplecaros]

I solved it!!!!!!!

I created a title on the top of the form, which is a text box that displays the current record name. I tried to match the name of the title with the displayed cbo

I tried:

Private Sub Form_Current()
Me.Proyectocbo = [Título]
End Sub


And it worked!!, thanks to your help, I couldn't have done that by my own.
Thank you VERY much.

[RuralGuy]

Outstanding! Thanks for posting back with your success. Go ahead and use the Thread tool and mark this thread as Solved.