You can hide the textboxes if you wish. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Get value from listbox and copy to control source of unbound textbox Ask Question. Asked 8 years, 11 months ago. Active 1 year, 4 months ago. Viewed 3k times.
Column 2 End Sub Any help is much appreciated thankyou! Improve this question. Erik A Add a comment. Active Oldest Votes. Column 2 End Sub Do not forget that columns are numbered from zero. To make the control read-only, set the Locked property to Yes. If you click a control bound to a field that has a Hyperlink data type, you jump to the destination specified in the hyperlink address. The control displays data generated by an expression.
This data can be changed by the user but isn't saved in the database. You can also set the ControlSource property for a text box by typing a field name or expression directly in the text box in form Design view or report Design view. For a report group level, the ControlSource property determines the field or expression to group on. Note: The ControlSource property doesn't apply to check box, option button, or toggle button controls in an option group.
It applies only to the option group itself. For reports, the ControlSource property applies only to report group levels. Forms and reports act as "windows" into your database. You specify the primary source of data for a form or report by setting its RecordSource property to a table, query, or SQL statement.
You can then set the ControlSource property to a field in the source of data or to an expression. If the ControlSource property setting is an expression, the value displayed is read-only and not saved in the database. For example, you can use the following settings.
Sam ple setting. For a control, data from the LastName field is displayed in the control. For a report group level, Microsoft Office Access groups the data on last name. Data Management. Tags: MS Access. There is no drop-down list that has anything to do with a ControlSource that will show Forms. Michael S. Anonymous Posted October 27, 0 Comments.
Thanks Grant. My form is working. Register or Login. Welcome back! Reset Your Password We'll send an email with a link to reset your password. Stay ahead! Get the latest news, expert insights and market research, tailored to your interests.
0コメント