Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / May 2008

Tip: Looking for answers? Try searching our database.

Items in a combo box

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Carlos1815 - 15 May 2008 16:42 GMT
I have an Access 2003 interface project (form) where in each
record, a designer can open a combo box (Row Source: SELECT [PageType].
[PageTypeID], [PageType].[PageType] FROM [PageType]) and choose one of
a small number of page types:

Topic Page
Objective Page
Comp Check Page
Last Page

The choice is read in Authorware and the applicable page is used.
However, this function works perfectly and this is not an Authorware
question!  The question I have is that once a designer chooses "Last
Page" in the Access form, I have all the controls turned off for the
last page and no new pages can be added and Authorware knows when the
end of the topic is.

What I'd like is for the Last Page choice in the combo box be
invisible, or taken out of the combo box list once it is chosen, so
that it can only be used once; the designer can scroll through the
preceeding pages (records) and change them to one of the other combo
box choices, but Last Page won't be a choice because it is already
being used.  If the designer wants, he can change the last page to
something else, and the Last Page would appear in the combo box list
again.  Right now, all choices are always available in the combo box.

Is there a way to do this?  I haven't found anything similar to this
question in this forum and was wondering if anyone had any insights.
Thanks!

Carlos
Mr B - 15 May 2008 23:15 GMT
Hi, Carols1815.

I would suggest that in the OnCurrent event of you form that is displaying
the PageType field you use code to check for the existance of a record (using
the appropriate criteria) where the PageType is equal to "Last Page".  If you
find that there is a record, you can then change the Row Source of the combo
box, leaving out the "Last Page" value.

Signature

HTH

Mr B
askdoctoraccess dot com

>      I have an Access 2003 interface project (form) where in each
> record, a designer can open a combo box (Row Source: SELECT [PageType].
[quoted text clipped - 27 lines]
>
> Carlos
Carlos1815 - 16 May 2008 15:35 GMT
> Hi, Carols1815.
>
[quoted text clipped - 43 lines]
>
> - Show quoted text -

That worked great, thank you!

Carlos
Mr B - 16 May 2008 16:18 GMT
Glad to help, Carlos.

Signature

HTH

Mr B
askdoctoraccess dot com

> > Hi, Carols1815.
> >
[quoted text clipped - 47 lines]
>
> Carlos
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.