visible option on 2nd record linked to first record

[50ld13r]

my form works fine on the first record of the database but now i have added a 2nd record some of the functionallity form the first record is applied to the second. At the moment in my table for each record i have a status field which speifies whether certain data is visible to the user or not. When i select visible = false on record one this is also appled to record 2. I dont want this and want each record to have there own specific status.

For example at the moment i have:

if me.combobox.value = 1

Me.mytxtbox.visible=true

else

Me.mytxtbox.visible=false

endif

This seems to apply the rule to all records not just the current one i am in. If explaination isnt clear i will gladly expand further

 

[rborob]

would
if me.combobox.itemdata(1) = true
Me.mytxtbox.visible=true
end
else
Me.mytxtbox.visible=false
end if

make a difference?

 

[50ld13r]

this code never seems 2 envoke the else section of the code. In essence what the program should do is if option1 is selected make details visible else make them invisible, i removed the end part from the if else stmt you gave as this made it freeze for some reason. What i put was:

if me.combobox.itemdata(0) = true
Me.mytxtbox.visible=true
else
Me.mytxtbox.visible=false
end if

selecting option1 was fine just getting option 2 2 work was the problem, thanks for your quick reply