Either/Or

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,
 
D

Douglas J. Steele

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.
 
R

Ron2006

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
 
A

aubrey

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,
 
Top