Help! Problems Populating a Combo box

Jill

Registered User.
Local time
Today, 15:40
Joined
Feb 21, 2000
Messages
18
Please help! I am encountering many problems populating a combo box.

I need the combo box to be a list of ip addresses based on an office id. Here's the catch. I need the combo box choices to be restricted by whether our network admin. has used an ip or not.

So, I'm thinking I could develop a form with a list of ip's w/ checkboxes. The network admin. could go in and if an ip has been used, just check it off. BUT, I then would like the combo box to be based on this form (table) of checked or unchecked ip addresses? So, basically if an ip address is checked off on this other form, I don't want it to show up in this combo box on my other form.

Does anyone have any ideas or suggestions on how I could get this to work? I am having a mental block, so whatever help I could get would be greatly appreciated!

Thanks.

[This message has been edited by Jill (edited 09-01-2000).]
 
Create a query based on the table. In the Criteria field of the Check Box column put "0" (that is a zero and leave off the quotes). This query will now show only IP address that have NOT been checked by Admin. Base your Combo Box on this query....

HTH,
Jack
 

Users who are viewing this thread

Back
Top Bottom