Items in a combo box

[Carlos1815]

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]

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.

 

[Carlos1815]

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.

--
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].
[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- Hide quoted text -

- Show quoted text -

That worked great, thank you!

Carlos

 

[Mr B]

Glad to help, Carlos.

--
HTH

Mr B
askdoctoraccess dot com

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.

--
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].
[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- Hide quoted text -

- Show quoted text -

That worked great, thank you!

Carlos