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
5  46768 
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
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.
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
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.
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
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Billy Jacobs |
last post by:
I have created a DataGridColumnDatePicker Component so
that I can put a datetimepicker control in my datagrid.
It almost works.
When I put my mouse in the cell it changes to a
datetimepicker...
|
by: MLH |
last post by:
I have created two forms: frmBrowseNegsMainform and
frmBrowseNegsSubform. I put a subform control on the
first of these. The SourceObject property for the subform
control is, of course,...
|
by: Roger |
last post by:
I've got a continuous form based on a query
the first 2 controls on the form are bound to columns in the query
a third control (paymentAmount) is unbound
I have a total control in the footer,...
|
by: John |
last post by:
Hi all,
This really is quite an urgent matter.
I have a page with multiple, dynamically-loaded user controls and when a
user clicks on a button, the whole form is submitted. Now at this stage...
|
by: moondaddy |
last post by:
I have a user control being used instead of a frame page. when the user
clicks on a menu item I need to send the ID (integer value) of that menu as
a parameter in the postback of the user control...
|
by: TCORDON |
last post by:
I have a user control that contains 2 image buttons, when you click one of
them, both must change the image source, the thing is that the first time
you click any one of them the page appears to do...
|
by: nate |
last post by:
the error returned is this:
Server Error in '/AnnAccRpt' Application.
--------------------------------------------------------------------------------
Could not find control 'DropDownList1' in...
|
by: ChasW |
last post by:
This should be most simple to do, and I am doing it elsewhere in the
very same form, but for some reason it is not working in this case.
My form uses a query as its Record Source.
In the form...
|
by: -D- |
last post by:
How can I turn the visibility of the xml control on or off?
<%@ Control Language="c#" AutoEventWireup="false"
Codebehind="TopNavBar.ascx.cs" Inherits="compass.user_controls.TopNavBar"...
|
by: Anja |
last post by:
Hi everyone,
I am trying to use the expression builder to create input to a control
in an Access report.
I have a table called Records and I want to select the minimum date for
a record where...
|
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: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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: 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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
