New record to appear in combo box

[Ela]

I have a Form where I enter in New Services details, when I click save I want that form to close and that New
Services's name to appear in a combo box on another Form - User Form and not only in the drop down of the combo box but in
the selected text part of the combo box. How may i do this?
Thank you,
Ela

 

[Alexandre]

For rexample, using the on close event of the form where users enter a new value:

Forms.Item("UserForm").Controls("HereGoesYourComboBoxName") = Me.NewValueTextBoxName

Alex

 

[Ela]

Thank you very much Alexander. It works!

I have also other problem with the records in combo box. Perhaps you can help me.

If I choose a record from combo box drop down and it appears in the field. Then I delete the record from the field and try to open linked to that field subform (Service).

But the I revived a warring (in Access 97):
" Syntax error (missing operator) in query expresion '[ServiceID]='. "

Thank you
E.

 

[Alexandre]

Sorry, but please reformulate

If I choose a record from combo box drop down and it appears in the field. Then I delete the record from the field and try to open linked to that field subform (Service).

It is just not clear to me.
And let me se the sql of your query

Alex