Art-
If it's a simple list box (not multi-select), just click on the value you want, and Access will highlight it. That becomes the "value" of the list box. In After Update, filter your subform.
John Viescas, author
John Viescas, author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Access Applications
On Jun 9, 2017, at 23:18, Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
How do I select the list box item and in return filter the appropriate subform with the selected item.
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Anyone who claimed that old age had brought them patience was either lying or senile."
From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, June 9, 2017 1:12 PM
Subject: Re: [MS_AccessPros] Populating a option group from table
Art-
Use the table that lists all the document types as the Row Source of the List Box. If you add a document type, it'll appear in the list the next time you open the form. You can use the List Box as the Link Master Fields of your subform to do the filtering.
John Viescas, author
John Viescas, author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Access Applications
On Jun 9, 2017, at 20:02, Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
OK. How would I do that?
I am thinking there would be no more than 20 entries max. Once they select the document type, I will present them a continuous subform that contains all the documents of that type.
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Anyone who claimed that old age had brought them patience was either lying or senile."
From: "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, June 9, 2017 12:47 PM
Subject: Re: [MS_AccessPros] Populating a option group from table
Art,
Have you considered using a list box?
Duane Hookom
Switzerland
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, June 9, 2017 12:15 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Populating a option group from table
Sent: Friday, June 9, 2017 12:15 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Populating a option group from table
What would you suggest? I need to be able to populate it on the fly?
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Anyone who claimed that old age had brought them patience was either lying or senile."
From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, June 9, 2017 11:36 AM
Subject: Re: [MS_AccessPros] Populating a option group from table
Art-
While you can certainly bind an Option Group to a field that has integer values, an Option Group is a static control. You can't add new values without editing the design.
John Viescas, author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Access Applications
| Welcome to the home of John Viescas Consulting. If you're at all interested in Microsoft Access or SQL Server, this is the place to be! Check out the book ... |
On Jun 9, 2017, at 18:03, dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Is there a way to populate an option group (toggle) dynamically from a table. I have a table called tbldoucmenttype (defined):
DoctypeId
doctypename
doctypeplural
doctypedesc
createddate
createdby
modifieddate
modifiedby
data included
List
Memo
Reports
Agenda
Minutes
I have a option group called ogDocumentType. As new data is added to the tbldocumenttype I would like the ogDocumentType updated to include the new entry...
Thank you,
Art Lorenzini
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (9) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar