Either/Or

  • Thread starter Thread starter aubrey
  • Start date Start date
A

aubrey

Hi,

I have two fields in my Query, which are dropdown lists: Issues I, Issues
II. I only want the user to be able to choose from one of these fields. How
do I make sure that the used only has the ability to choose one of the fields?

Any help would be great.

Thanks,
 
My approach would be to open the form, let them select their parameters and
then click on a button to launch the query. You'd put logic in the button's
Click event to validate their input before you launched the query.
 
Onthe form where they are updating the fields:



Issue1 afterupdate event.
if isnull(me.issue1) = false then me.issue2 = null



Issue2 afterupdate event
if isnull(me.issue2)=false then me.issue1 = null

Ron
 
Hey Doug,

Thanks for the reply. The user in the front end would not be launching the
query, mabey I worded my question wrong. The user would be selecting an
option from one of the two fields in the form, but i want to ensure that they
can only select from one of the fields and not both. How would I do that?

Thanks againg for your help.

Aubrey,
 
Back
Top