Design question

[MaxEd]

Is it essential to create a data entry form and a data viewing form? One scenario that I have always runned into is making a combo box and the data from the combo box is a lookup table. Now the problem I have is when the data from the lookup table goes obsolete, it will still show up in the combo box, if I decided to hide them buy querying out those who a "obsolete" criteria then going back to view those on the data entry screen becomes a problem because they don't show up in the combo boxes. Has anyone encountered the same issue before?

-Laughter works miracles.

 

[dhookom]

I have a field in the lookup table that I can check if the value is Active or Inactive. I sort the inactive values to the bottom of the combo box list. I may also use code in the after update event to see if the user selected an inactive value and then bop them over the head.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[MaxEd]

Duane,

I think that sounds like a great idea. Thanks!! I will definately put that to good use because the users are complaining about the obsoleted items.

-Laughter works miracles.

 

[JonFer]

I agree, bopping them on the head will reduce those complaints. It is a flexible solution, too, for any future problems.