Control Sources

[0bsidian]

I have created a form which has a series of cascading combo boxes in it to assist the user in selecting the appropriate information.

However I want to use this form as an input method to a table in the database.

I know that I can link a field on a form to a table field using Control Source (in Properties) however, this is likely to impact the functionality of the combo box itself.

Is there a formula I can assign to control source to do this, or can anyone suggest a different/better way?

Thanks in advance.

0bs

 

[JANR]

Bind the form to your table/query and set the controlsource to the correct field you need to update.

JR