masking a combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I have a combo box that I can select 1-12 which then passes that selection
to a textbox (there are 12 textboxes).
if I select 1 to be in textbox 1 and then re-select for textbox 2 I want 1
not be visible in the combo box as it has been used so if I select 1,2,3,4,5
in textboxes 1-5 when I come to 6 I only have a choice of 6-12. Then move to
the next record all 12 are available again. I thought I could use a query and
set the criteria to if used don't show it but I am not sure how to do it.

Thanks in advance

Frustrated
 
Arnie,

What is the SQL that you are using for your combo box, or are you using a
value list as the row source type?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use txtboxes and Combo boxes in a form 3
PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
Combo box query 2
Viewing expressions in a listbox 4
Search on entered or blank criteria 5
Multiple criteria from a textbox? 2
optional paramters to a query 1
Combo box text clearance problem 8

Back
Top