New Field Properties in Form

[towel1981]

I created and new field and made the source "Unbound" so that it is not connected to the field I copied it from. How do I now make that the information I enter in the new field does not duplicate in all of the similar fields in other entries.

Specifically, my database is a database of employees and the field Title is "Active". If I enter "Yes" by one employee entry, all employee entries will then state "Yes" by the Active field.

How can I change the properties so that by some employees I can write "Yes" and by others I can enter "No".

I am not so familiar with Access so if you can be specific I would greatly appreciate it.

 

[ScottGem]

I created and new field and made the source "Unbound" so that it is not connected to the field I copied it from. How do I now make that the information I enter in the new field does not duplicate in all of the similar fields in other entries.

Specifically, my database is a database of employees and the field Title is "Active". If I enter "Yes" by one employee entry, all employee entries will then state "Yes" by the Active field.

How can I change the properties so that by some employees I can write "Yes" and by others I can enter "No".

I am not so familiar with Access so if you can be specific I would greatly appreciate it.

Let me first clear up some terminology here. You don't add fields to a form. Fields are logical divisions of records in a table. On forms you add controls that may or may not be bound to a field in a table. This is a subtle but very important distinction.

You should have an Active field in your table. Then set the ControlSource to that field. This will bind the control to the field so that the data entered in the control is stored in the record in that field and the control reflects the data stored in that field for existing records.

P.S. I just noticed you asked basically the same question in a different thread. Its not a good idea to create different threads. If you need followup post a reply in the original thread.

 

[towel1981]

Active Field

Hi Scott,

I think I understand what you are referring to and I have somehow made that the "Active" field is not bound to any other fields on the form. However, it is connected to the "active" field by all other entries - if I type "Yes" by one person it says "Yes" by everyone. I don't want to be a pain but I am so unfamilar with Access so if you can provide me with specifics that would be soo greatly appreciated. If there is a way I can contact you by phone I would be more than glad. Thank you.

 

[ScottGem]

Hi Scott,

I think I understand what you are referring to and I have somehow made that the "Active" field is not bound to any other fields on the form. However, it is connected to the "active" field by all other entries - if I type "Yes" by one person it says "Yes" by everyone. I don't want to be a pain but I am so unfamilar with Access so if you can provide me with specifics that would be soo greatly appreciated. If there is a way I can contact you by phone I would be more than glad. Thank you.

You are looking at the form, not the table. When you set the value of an unbound control that control maintains its value when you move from record to record on the form. So it appears that all records have the same value. But if you look at the table, you will see that the field is actually blank because the control is not bound to the field.

All you need to do is set the ControlSource to the field in the table to bind it.

 

[ScottGem]

Hi Scott,

I think I understand what you are referring to and I have somehow made that the "Active" field is not bound to any other fields on the form. However, it is connected to the "active" field by all other entries - if I type "Yes" by one person it says "Yes" by everyone. I don't want to be a pain but I am so unfamilar with Access so if you can provide me with specifics that would be soo greatly appreciated. If there is a way I can contact you by phone I would be more than glad. Thank you.

It sounds like you are looking only at the form, not the table. When you enter a value into an unbound control, the control retains that value as your change records. But if you look at the table the field is actually blank because the value isn't being stored because no control is bound to the field.

All you need to do is change the ControlSource to the field.

 

[towel1981]

Control Source

Scott, I appreciate your help, but as I am inexperienced with Access, I do not know how to proceed and implement the suggestions you made. Is there anyway I can reach you to obtain step by step simplified directions?

Thanks again!

 

[Scatman]

towel,

I think what they are trying to tell you is to create a field in your TABLE called Active. The field should be made a yes/no field. You can do this when you create the field. Your form's control should then use the table field Active as its control source. After this is done, when you view your form, it should show as active for those employees that are currently active.

Hope this helps

Scatman

 

[ScottGem]

Scott, I appreciate your help, but as I am inexperienced with Access, I do not know how to proceed and implement the suggestions you made. Is there anyway I can reach you to obtain step by step simplified directions?

Thanks again!

I think I've been pretty clear in my instructions both here and on UA. (I assume that was you asking the same question on UA).

Since you previously stated that you had set the ControlSource to Unbound then you should know how to set the controlsource of a control. But just in case I'll repeat the steps:

Right click on the control and select Properties
Select the Data tab
Click in the Controlsource box and pull down the list of fields
Select the appropriate field

If you want to consult with me over the phone or via IM, that is possible but I charge a fee for that.