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

Binding an unbound control to a field

P: 3
Not as simple as the title suggests, and I am at my wits end. I have only basic knowledge of Access, so this is probably a very simple question for everyone else.

The situation:

I have a form that was created in wizard. Up until now it has had all the fields it needs to function in it's role as a data entry form.

Now my boss wants me to add fields that connect to new tables so that we can collect more data. I have created the new tables and relationships, but these new tables are not in my field list, so I cannot use the drop down box in "control source" under properties, as all the books, help guides and web tutorials keep telling me.

The only other piece of information that was semi useful was to type in the control source, but I have no idea how to do this or what to include. I tried using the expression builder but it came out with Name#

Basically what I need to know is how to add fields from the new tables to my field list, or how to type in the control source properly.

Much thanks for any help
Jul 18 '07 #1
Share this Question
Share on Google+
5 Replies


P: 16
Not as simple as the title suggests, and I am at my wits end. I have only basic knowledge of Access, so this is probably a very simple question for everyone else.

The situation:

I have a form that was created in wizard. Up until now it has had all the fields it needs to function in it's role as a data entry form.

Now my boss wants me to add fields that connect to new tables so that we can collect more data. I have created the new tables and relationships, but these new tables are not in my field list, so I cannot use the drop down box in "control source" under properties, as all the books, help guides and web tutorials keep telling me.

The only other piece of information that was semi useful was to type in the control source, but I have no idea how to do this or what to include. I tried using the expression builder but it came out with Name#

Basically what I need to know is how to add fields from the new tables to my field list, or how to type in the control source properly.

Much thanks for any help
Hi Cassandra

I am pretty sure that you can't do what you are talking about.

If the data in the new tables is one to many with the first table then have a look at sub forms, they are the go in this case. If the relationship is one to one then you should probably be extending your primary table instead of creating new ones.

Hope this helps.
Jul 18 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Not as simple as the title suggests, and I am at my wits end. I have only basic knowledge of Access, so this is probably a very simple question for everyone else.

The situation:

I have a form that was created in wizard. Up until now it has had all the fields it needs to function in it's role as a data entry form.

Now my boss wants me to add fields that connect to new tables so that we can collect more data. I have created the new tables and relationships, but these new tables are not in my field list, so I cannot use the drop down box in "control source" under properties, as all the books, help guides and web tutorials keep telling me.

The only other piece of information that was semi useful was to type in the control source, but I have no idea how to do this or what to include. I tried using the expression builder but it came out with Name#

Basically what I need to know is how to add fields from the new tables to my field list, or how to type in the control source properly.

Much thanks for any help
The current record source of your form is the original table. You can replace this with a query to include the other tables as long as all the tables have a one to one relationship. This will make the fields available in your field list box.

However, if those tables have a one to many relationship with the original table you will need to add a subform to handle those records.
Jul 18 '07 #3

P: 3
Subforms it is, thankyou very very much
Jul 19 '07 #4

P: 3
Hi Cassandra

I am pretty sure that you can't do what you are talking about.

If the data in the new tables is one to many with the first table then have a look at sub forms, they are the go in this case. If the relationship is one to one then you should probably be extending your primary table instead of creating new ones.

Hope this helps.
Looks like subforms are my answer, thankyou so much for your help :D
Jul 19 '07 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
Looks like subforms are my answer, thankyou so much for your help :D
You're welcome Cassandra.

Glad its working for you.
Jul 19 '07 #6

Post your reply

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