Drop down

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

Guest

Hello
Maybe you can help me

I have Table1 with the following fields
SerialNo IN/OU

IN/OUT has a Yes/No optio

In Form1 I have
SerialNo(dropDown) In/Out(Check Option
Is there any way to have this drop down option in Form1 to display only serial numbers from Table1 that are uncheck only
Also If I choose a serial number and I put a check mark will substracted from the drop down list

Thank you
 
Hi Oscar

use the combobox property, Row Source. Click the builder button (...) to view the sql. If required add the In/Out field to the qbe grid. Type in the criteria row for this field the valu
FALS

This will then only return unchecked records. Add the following line to the afterupdate event for the checkbox contro
cboSerialNo.requer

Substitute cboSerialNo for the name of your combobox

Luc
Jonathan

----- Oscar wrote: ----

Hello
Maybe you can help me

I have Table1 with the following fields
SerialNo IN/OU

IN/OUT has a Yes/No optio

In Form1 I have
SerialNo(dropDown) In/Out(Check Option
Is there any way to have this drop down option in Form1 to display only serial numbers from Table1 that are uncheck only
Also If I choose a serial number and I put a check mark will substracted from the drop down list

Thank you
 
Back
Top