Need help with bound control

[darrellx]

I have an unbound control in a form that I have set up to allow me to choose between cash or credit. However if I choose one or the other it automatically puts it in all records. I have added a field in one of my tables where it allows for me to choose cash or credit, but I can't figure out how to change the existing unbound control in this form to a bound control linked to the field in the table I added. Any help would be appreciated.

Thanks

Darrellx
Edit/Delete Message

 

[missinglinq]

Right click on your textbox, click on Properties - Data and under Control Source set it to your new field. If your form is based on a query rather than a single table, you'll have first update your query to include the new field, then set the Control Source for the control to the new field.

Good Luck!

Linq

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[darrellx]

I tried to change the control source but it doesn't show the table that this field is in. How can I open this table while in properties of that field in the form?

Thanks

 

[missinglinq]

In order to bind a control on your form to a field in a table, the table the field resides in must either be the RecordSource for the form, or part of the Query that is the RecordSource for the form. Unless one of these conditions is true, you can't bind the control to the field! As I said in my last post, if the form is bound to a query, you have to go into the query and add the new field to it. When you open the ControlSource box for the control in question, you shouldn't have to "open the table" the field is in, the field should be right there, available for selection.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!