Oh, and Text3 is equal to this:
=DateSerial([cboYear],[cboMonth],[Text6])
And Text6 is equal to this:
=IIf(Text6.Tag= Weekday(DateSer ial([cboYear],[cboMonth],1)),1,Text5+1)
cwhitcomb2
Last Activity: Dec 18 '07, 09:03 PM
Joined: Jul 25 '07
Location:
-
Alright,
I have exhausted all the possible ways to write a rowsource for this listbox. NOTHING is working. Nothing. I have tried to write it by refering to the controls on the form like you suggested and nothing. I tried to write it without using Forms!FormName! Control and still nothing. In fact, all this listbox seems capable of returning is nothing. Here is my current rowsource syntax:
SELECT Projects.[Project#],...Leave a comment:
-
How do I go about doing that?
I don't know how to rephrase the syntax to fit that in.Leave a comment:
-
Problems with Listbox Rowsource in MS Access 2003
I have created a form in my database that resembles a calendar. I have 42 textboxes that display the day of the week for whatever month and year is selected in the combo boxes at the top of the form. The text boxes are named Text1, Text2, etc. The combo boxes are named cboYear and cboMonth.
Here is the problem: I put a listbox under each textbox that should show the project# for the projects that are active on that day. I'm using...
No activity results to display
Leave a comment: