I'm sorry, it still isn't working, I have tried everything.
Salutation appears in the table in normal view and design view. It is also in the list of fields when I look at the relationships.
The problem is, in the form - every other field from the table is listed but the new field i have added; salutation, does not appear in the field list, or the control source drop down list.
The form is simply not recognising that a new field has been added, even though it is blatantly there in the table and every other aspect of the database!
Nat
PREVIOUS MESSAGES: (I think my old message/reply was closed, I can only get to my PC twice a week usually).
I have added a new column in my table (Salutation), but in my form, after adding a text box to enter in this information, 'Salutation' it is not listed in the field list and I therefore cannot operate it. Any thoughts on how to overcome this?
Many thanks.
expublish
Senior Member
Is your form based directly on the table or on a query based on the table. If it based on a query make sure you have updated the query with the extra field.
If it is based directly on the table then, I know this sounds trivial, check that the record source of the form is correct. Also try adding the field without using the wizard (the magic wand should not be pressed) and in the control source use the drop down menu. I have just tried this on a test DB and it works.
Post back with any problems.
Scott.
NGilbert
Junior Member
The form is based on the table alone. To add the new column I simply went in to the table and 'added column'.
I have tried adding a text box with and without the wizard in the form, but either way, when I go in to Control Source - the new column 'Salutation' is not appearing on the drop down list - it is listed everywhere else that I can see but is just not corresponding to the form?
How do I check 'record source' as you suggested?
Thanks, I am a complete novice - bear with me!
David R
Senior Member
Two options:
Bring up the Field list on your form while in Design View. It looks like a 'page' button on the toolbar, or it's under View. At the very bottom (assuming you added this field to the end of your table) of the list is your new field. Click and drag it onto your form to add the new field.
Alternatively, try adding a new blank text box as expublish mentioned. Bring up the Toolbox and click on Text box, then click on your form. A new field will come up, named some nonsense like "Text76". That is part of why I don't like this method when I can avoid it. Now if you double-click on this field, or right click and select Properties, you will get the Properties screen for that field. Under the data tab the first option is Control Source. You can drop-down that list and select Salutation the same way.
Post back if you're still having problems.
Salutation appears in the table in normal view and design view. It is also in the list of fields when I look at the relationships.
The problem is, in the form - every other field from the table is listed but the new field i have added; salutation, does not appear in the field list, or the control source drop down list.
The form is simply not recognising that a new field has been added, even though it is blatantly there in the table and every other aspect of the database!
Nat
PREVIOUS MESSAGES: (I think my old message/reply was closed, I can only get to my PC twice a week usually).
I have added a new column in my table (Salutation), but in my form, after adding a text box to enter in this information, 'Salutation' it is not listed in the field list and I therefore cannot operate it. Any thoughts on how to overcome this?
Many thanks.
expublish
Senior Member
Is your form based directly on the table or on a query based on the table. If it based on a query make sure you have updated the query with the extra field.
If it is based directly on the table then, I know this sounds trivial, check that the record source of the form is correct. Also try adding the field without using the wizard (the magic wand should not be pressed) and in the control source use the drop down menu. I have just tried this on a test DB and it works.
Post back with any problems.
Scott.
NGilbert
Junior Member
The form is based on the table alone. To add the new column I simply went in to the table and 'added column'.
I have tried adding a text box with and without the wizard in the form, but either way, when I go in to Control Source - the new column 'Salutation' is not appearing on the drop down list - it is listed everywhere else that I can see but is just not corresponding to the form?
How do I check 'record source' as you suggested?
Thanks, I am a complete novice - bear with me!
David R
Senior Member
Two options:
Bring up the Field list on your form while in Design View. It looks like a 'page' button on the toolbar, or it's under View. At the very bottom (assuming you added this field to the end of your table) of the list is your new field. Click and drag it onto your form to add the new field.
Alternatively, try adding a new blank text box as expublish mentioned. Bring up the Toolbox and click on Text box, then click on your form. A new field will come up, named some nonsense like "Text76". That is part of why I don't like this method when I can avoid it. Now if you double-click on this field, or right click and select Properties, you will get the Properties screen for that field. Under the data tab the first option is Control Source. You can drop-down that list and select Salutation the same way.
Post back if you're still having problems.