combo box same on form page

[kimmieboot]

Hi, i have created a combo box that lists first name, surname, address of
employees. I also created text boxes which look up this information to
display it on the form. This all works great. But when you go from one
record to another the combo box is stuck on the same record - it enters the
same employee details for every record ! Can anyone tell me how to make
the combo box to only change the current record i am working on.

Any help is most appreciated.

 

[mcnews]

Hi, i have created a combo box that lists first name, surname, address of
employees. I also created text boxes which look up this information to
display it on the form. This all works great. But when you go from one
record to another the combo box is stuck on the same record - it enters the
same employee details for every record ! Can anyone tell me how to make
the combo box to only change the current record i am working on.

Any help is most appreciated.

is the combo box bound to a coulumn that is in the table/query that is
bound to the form?

 

[kimmieboot]

is the combo box bound to a coulumn that is in the table/query that is

bound to the form?

hi, it is bound to a table/query that is different to the table on which i
have created the form.

The combo box is based on the tabled called 'facilitators'
and the form is based on a table called 'contact details'

 

[mcnews]

hi, it is bound to a table/query that is different to the table on which i
have created the form.

The combo box is based on the tabled called 'facilitators'
and the form is based on a table called 'contact details'

well you need to have something that will update the combo when you
navigate.
either some record manipulating code in the on current event or link
the combobox source to the bound form's source.

 

[kimmieboot]

hi, thanks for getting back to me, your answer seems very logical, but I am
having problems in how to do this.... are you able to give instructions ????
i am not very good at coding I only have basic skills in creating forms and
list boxes that are linked to one field, not to many. If you could further
help me, it would be appreciated. Thanks.

 

[mcnews]

hi, thanks for getting back to me, your answer seems very logical, but I am
having problems in how to do this.... are you able to give instructions ????
i am not very good at coding I only have basic skills in creating forms and
list boxes that are linked to one field, not to many. If you could further
help me, it would be appreciated. Thanks.

might be easier if you could zip up and send to mcbassguitar @ yahoo.
com