Details Display

[mccurrym]

I have a form in which I have the Details hidden. When the form opens I have a combo box in which the user makes a selection. This determines which fields will be displayed in the details. The problem I am having is that after the selection is made I need all of the fields to be blank for data entry. (I can get this to work on the on open event when I dont have the details section hidden)


I have tried several things on the afterupdate of my combo but have had not luck. Does anyone have any suggestions.


Thanks in Advance,

Been out of pocket for a while.


MSM

 

[llkhoutx]

Use the tag property for each object to hold a value indicating which combo box value is associated with it.

Then on the combo box afterupdate event, cycle through all objects, setting each value to null and checking the tag and where appropriate displaying those (set visible property to true).

Litwin's Access Developer's (Desktop) Handbook, all editions, has the code for this.

You'll be supprised how fast the code is.

Alternatively,

me!object1=""
me!object2=""
me!object3=""
etc.

if me!mycombo = "Value1" then
me!object1.visible=true
etc.
elseif me!mycombo = "Value1" then
me!object2.visible=true
etc.
elseif me!mycombo = "Value1" then
me!object3.visible=true
etc.
end if