Listbox and checkbox

T

Tim

Hi everyone,
I've been trying to find out a way to link these two together and also
implement a function to update all the records at once if i need to. So far
this is what i have,

Table: Users
Field1: User_Name, text
Field2: Date, date
Field3: Kick, yes/no

Form: Users_Connected
listbox, where the Row source is the Users table, control source is
Computer_name.
Checkbox, where the row source is the users table, control source is kick.

I cant seem to figure out how to get the checkbox to correspond correctly
with the listbox, can someone give me further guidance? So if i select a
value in the listbox i want to see the checkbox(Kick) for that value.


Second question is about after i get those two to work together, everytime i
do the checkbox i'll have to write an after_update function so that it saves
the table, correct?

Thanks,

Tim
 
Top