changing form view based on a value in a text box.

[MMIMadness]

i have a access 2k3 form and it displays the results of a serch by using a filter sent from another form.

the table that the form hold gets its data from is a flat table but holds information about 4 differant items which share the same feilds, and has a item_type column to identify what the item is.

what i want to do is once the form has been opened a peice of code to run and check the vlaue of the Item_type text box and then hide the boxs that arn't required for that item type. i can get it to work if i put the code behind a command button but i can't work out how to do it when the page is opened.

Any ideas.

Many thanks

A

 

[lameid]

Sounds like you want the forms on current event instead of a buttons click event.