COPY INPUT FROM COMBO TO FILL-IN FORM

[Angelique]

When the user types in the combo box an item not in the list, it tiggers the Client form.

If the user types in a different client name to what was typed in the combo box, it retriggers the not in list error message.

Is there a way that I can copy the original string in the combo box into the new record on the Client form? This would save the user retyping and stop the error message.


Angelique

 

[kathryn]

Yes, you can do this. In your NotInList event, I am assuming that you have code to open your Client form. When you open a form, it is possible to pass an argument to the newly opened form. Look at the OpenArg argument of the OpenForm method.

If you use something like this:

docmd.OpenForm "frmClient",,,,,,,Me!ValueofComboBox

(check the number of commas, I won't swear I got them right)

then in your frmClient, you can refer to the ValueOfComboBox using the OpenArgs Property of frmClient.

Hope this gets you started. Kathryn

 

[Angelique]

Dear Kethryn

Thanks, I'll try that but one question in reference to the OpenArgs property of the frmClient? How do I do that?

Angelique

 

[kathryn]

While you are in the frmClient, just refer to Me.OpenArgs

Look at the OpenArgs property in the Help Files.

Hope that helps. Post if you need more. Kathryn