If "Other" Selected

[hulksdgt]

Hi, I'm relatively new to Access 2003 but have been managing quite well until
now. I have created a report and a query but need to filter out certain
information. My fields are:

Referral Made by: (drop down list)
Referral Other: (memo box)

Basically I want to be able to filter that if Referral is made by "Other"
then the "Referral Other" will be entered in its place.

Any help with this would be most appreciated.

Paula

 

[KARL DEWEY]

Sounds like you want the contents of a memo field to be enter in a field that
uses a drop down list. Is this the correct?

 

[hulksdgt]

Sort of, within my Referral Made By list there is an option to select "Other"
and I have created a new memo field to allow the text to be entered into. In
my report, I want it to put in the memo field if "Other" was selected.

 

[KARL DEWEY]

I did not understand your response of 'Sort of.' Now it sounds like you
want the memo field to contain 'Other' if the drop down list selection is
'Other.'

Use an event to Set Value of memo field on update of the the drop down list
with an IIF statement.