Adding a field to a form and getting error

[MNtoAZ]

I have inherited an access database at work and the person who created it is no longer with us and I need to add a field. We are using Access 2000 for Windows and I have the for dummies book for that version, but I'm not able to find the answer to my question.

I have no experience with Access, so I need an explanation that is not too technical. The error I have is a "Invalid Control Property: Control Source" I'm thinking I might need to add this to the field list, but I have no idea how to do that. Right now if I close out of design view and type in the field every single field changes and is the same for all forms.

If you can help me I'd greatly appreciate it! I tried searching the forums for this answer, but it kept pulling up no answers. I apologize if this has been addressed before.

 

[RuralGuy]

Are you adding a field to a form or to a table?

 

[MNtoAZ]

To a form... I think I'm doing it backwards, but I really have no clue what I'm doing!

 

[RuralGuy]

I will assume the form is bound (has a RecordSource). You will first need to add this field to the table pointed to by the RecordSource. Why do you believe you need another field? Sometimes extra fields are not required to achieve the desired effect.

 

[MNtoAZ]

My boss has requested that I add another field so he can show who is doing what in the report that prints. How do I add the field to the table?

 

[RuralGuy]

Can you open the table in design mode? If so, then scroll down to the bottom of the list and just start by typing a field name in the 1st open row. Are you planning to have a name on each record in the table? I hate to throw this at you but you should probably have a new table with the available people and then this table just has the primary key to the "People" table.

 

[MNtoAZ]

Should I just start a new table?

 

[RuralGuy]

Is there already a table in your system with these people in it?

 

[MNtoAZ]

No, not right now

 

[RuralGuy]

Go ahead and create a new table and use an AutoNumber as the Primary key to the table. Have separate fields for first and last name.

 

[MNtoAZ]

O.K. done...I was trying to import that into the form...but am still having trouble...

 

[RuralGuy]

Is the RecordSource of your form a table or a query? Have you added the new field to this table as well? It should be a numeric LongInteger field.

 

[MNtoAZ]

I finally got it to work! Thanks for all your help!!!

 

[RuralGuy]

Excellent! Thanks for posting back with your success.