By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,494 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

How to set Control Source on a form

P: 24
Hello,

Not familiar with Access and I have th efollowing question.

There ia a form which has few fields which are being pulled from a table.

Now I added few new columns to this table which I need to show it on the form.

When I create the text box and look in the properties/COntrol SOurce, the new fields are not being populated.

What needs to be done to see them in the COntrol SOurce?

Thanks,
YMK
Nov 21 '06 #1
Share this Question
Share on Google+
5 Replies


blyxx86
100+
P: 256
Look at the properties of the other fields on your form and follow the generic format, of course changing the new fields on your form to match the corresponding table column.
For example, I have a field on my form titled Date.. it's control source (and the column in my table) are all labeled Date.

However, if the forms rowsource is not directly related to the table in question the control source may look something like...
= [TableName]![Date]
in which case you would need to fill in the control source of your fields like...
= [TableName]![YourTableColumnName]

hope that helps you!
Hello,

Not familiar with Access and I have th efollowing question.

There ia a form which has few fields which are being pulled from a table.

Now I added few new columns to this table which I need to show it on the form.

When I create the text box and look in the properties/COntrol SOurce, the new fields are not being populated.

What needs to be done to see them in the COntrol SOurce?

Thanks,
YMK
Nov 21 '06 #2

P: 24
ymk
Look at the properties of the other fields on your form and follow the generic format, of course changing the new fields on your form to match the corresponding table column.
For example, I have a field on my form titled Date.. it's control source (and the column in my table) are all labeled Date.

However, if the forms rowsource is not directly related to the table in question the control source may look something like...
= [TableName]![Date]
in which case you would need to fill in the control source of your fields like...
= [TableName]![YourTableColumnName]

hope that helps you!
Thanks for the posting.

I figured it out by looking at the other fields.

The details are being pulled from a query where I needed to add these new columns to show upo in the control source.

Thanks.
Nov 21 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Thanks for the posting.

I figured it out by looking at the other fields.

The details are being pulled from a query where I needed to add these new columns to show upo in the control source.

Thanks.
For future reference.

When a form is bound to a table or query (Record Source is set) then a field list is available.

Go to the View Menu and choose Field List. Dragging these fields onto the form will create your new controls automatically set to the correct control source.

If you want to try this be sure to delete the textboxes you created manually first as this could cause naming conflicts.

Mary
Nov 21 '06 #4

missinglinq
Expert 2.5K+
P: 3,532
His form is based on a Query. He added fields to his table, but neglected to go back and add them to the Query . That's why they weren't showing in the Field List. I think, from his 03:28PM post, that he's figured this out.
Nov 21 '06 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
His form is based on a Query. He added fields to his table, but neglected to go back and add them to the Query . That's why they weren't showing in the Field List. I think, from his 03:28PM post, that he's figured this out.
Thanks

I missed that one

Mary
Nov 21 '06 #6

Post your reply

Sign in to post your reply or Sign up for a free account.