combo box/subform limit

[kris9]

I have a combo box with 5 options within a subform - Continuous Forms view.



Option within a combo box is selected and select date for it. After selecting all 5 options, Combo box shouldn't display other options to select. Or limit the subform to only 5 records.

Any suggestions ?

[June7]

What is the source of the combobox options - a table or value list? Want to provide db for analysis? Follow instructions at bottom of my post.

[kris9]

hi, sent you PM

[June7]

What form is involved in issue?

[kris9]

sent you pm. Form is tblUsers

[June7]

This concerns the combobox in the subform on the Comms Tracking tab?

Options:

1. create the set of five records all at one time and instead of combobox make the control a locked textbox - all user does is enter the date for each step

2. unbound form with 5 'rows' of unbound controls and use code to save record

This thread discusses both of those options https://www.accessforums.net/forms/checklist-35706.html

3. restrict the combobox RowSource after each record is created - problem with this is your subform is in continuous view and the combobox RowSource is a lookup saving the step ID instead of the step description. When the combobox is restricted to eliminate steps already used, the description alias is not available and the combobox will be blank. Only ways to handle this are to have a textbox display the related alias description or to save the description to tblCommsTracker

[kris9]

thanks for this.. will you be able to show me an example please.. and PM me..

This concerns the combobox in the subform on the Comms Tracking tab?

Options:

1. create the set of five records all at one time and instead of combobox make the control a locked textbox - all user does is enter the date for each step

2. unbound form with 5 'rows' of unbound controls and use code to save record

This thread discusses both of those options https://www.accessforums.net/forms/checklist-35706.html

3. restrict the combobox RowSource after each record is created - problem with this is your subform is in continuous view and the combobox RowSource is a lookup saving the step ID instead of the step description. When the combobox is restricted to eliminate steps already used, the description alias is not available and the combobox will be blank. Only ways to handle this are to have a textbox display the related alias description or to save the description to tblCommsTracker

[June7]

I prefer responding in threads as much as possible.

You want an example of which? Did you review the referenced thread? That is an example.