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
5  3683 
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.
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.
Subforms it is, thankyou very very much
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
Looks like subforms are my answer, thankyou so much for your help :D
You're welcome Cassandra.
Glad its working for you.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: JD Kronicz |
last post by:
Hi .. I have an issue I have been beating my head against
the wall on for some time. I am trying to use late
binding for MS graph so that my end users don't have to
worry about having the right...
|
by: Cameron Laird |
last post by:
Hi,
I'm using Stephen Lebans RTF control in an unbound Access 2000 form.
To populate the control I simply set the RTFtext property to the value
of the memo field in the database containing the...
|
by: Dos Lil |
last post by:
I have a unbound field in the subform(for calculating the datediff)
which has the control property ==DateDiff("n",,).
I have another unbound field in the main form which is for displaying
the...
|
by: Pat |
last post by:
Hello,
I've used Sum() to total bound fields on a continuous form with no problem.
However, I now have a continuous form, on which I use an unbound field to
calculate the number of hours between...
|
by: Jim M |
last post by:
To prevent data corruption I have replaced a memo field on my form with
an unbound control on my form that I populate with a function that
fills it from a memo field from my table. When the form is...
|
by: David |
last post by:
Hi
I seem to be getting nowhere with this. I am opening a form which will
be used to input Notes into different fields in a table. My problem is
changing the unbound field name to the field name...
|
by: Rourke Eleven |
last post by:
I have looked and searched. What good is the databind property on
Radiobuttons? How does one go about actually using it? What is a good
resource on this? I understand that I can easily get/set...
|
by: TORQUE |
last post by:
Hi,
Im wondering if anyone can help me with a problem.
I have a form with more than 50 unbound fields.
Some of the fields will be blank from time to time.
This seems to be where im having...
|
by: DeZZar |
last post by:
Hi all,
Unfortunately I am quite a novice with Access!! I've created a number
of data bases for my work however becuase my skills are limited to
really built in functionality and wizards my...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |
