Calendar Birthday Question

[kirklandwater123]

So I have a table of people's birthdays, along with a calendar and a text box in a form. I want to click a date on the calendar, such that the date only displays in the text box if it matches one of the person's birthdays.

I tried coding something like this:

If me.calendar0.value = 1/1/2010 then
text0 = me.calendar0.value
else if


text0 = ""

*apologize if this should be under programming instead*

[ajetrumpet]

so what happens with your current setup?

[kirklandwater123]

what happens now is that is just keeps displaying the values of whatever i click. i refreshed, saved, exited and reopened the form, still the same.

and then if i try to tweak it, it won't display the value at all.

[ajetrumpet]

what happens now is that is just keeps displaying the values of whatever i click. i refreshed, saved, exited and reopened the form, still the same.

and then if i try to tweak it, it won't display the value at all.

well if you've already got it to display the value that you click on, that's all the work. now, just add a DCOUNT() function after the part of the code that captures the value:

'code that captures the calendar date

if dcount("birthdayfield", "table", "[birthdayfield] = #" & valuefromcalendar & "#") > 0 then
   'fill the box!  woohoo, it's someone's bday today!
else
   'don't do anything
end if

[Access_Blaster]

As Adam pointed out you need a "birthdayfield" to compair against your me.calendar0.value. Then you can say if me.calendar0.value = "birthdayfield" then "birthdayfield" = text0 or at least start to sort it out.