List Box or Combo Box

[Libby]

I am working with an existing database. The form is pretty complex and pulls
from several different tables. One section states Years to Display and they
currently have it set up to just display one year. I want to make list boxes
that state Start Date (mm/dd/yy) and End Date (mm/dd/yy) to display more
information. Everytime I try to add these boxes though they do not work.
What am I doing wrong?

 

[KARL DEWEY]

Everytime I try to add these boxes though they do not work. What am I
doing wrong?
Exactly what is the results? No records, wrong records, error message, etc.?

Try using textboxes to enter the start and end dates.

 

[Libby]

Hey Karl, thanks for getting back to me! It isn't pulling any data even
though I know for a fact there is data under the dates inputted. I did try
text boxes as well, same results. Kind of hard to explain without you
actually seeing the form.

 

[KARL DEWEY]

Post the SQL of the query you are using as source for the form.

 

[Libby]

this is all it says for the SQL:
SELECT DISTINCT Year([ClassDateStart]) AS Expr1
FROM tblClasses;

sorry, I am a novice with Access

 

[KARL DEWEY]

The form is pretty complex and pulls from several different tables.
The SQL you posted is pulling data from one table and only one field -
ClassDateStart.
For a 'complex' form you just gotta have more than that as source for the
form.
Open the form in design view, click on menu VIEW - Properties. Read what it
says for Record Source.
--
KARL DEWEY
Build a little - Test a little

this is all it says for the SQL:
SELECT DISTINCT Year([ClassDateStart]) AS Expr1
FROM tblClasses;

sorry, I am a novice with Access

Post the SQL of the query you are using as source for the form.

 

[Libby]

Karl,
Thank you for your help. You are right, it is pretty complex and makes no
sense. Even when I click on properties it doesn't tell me anything. So I am
going back to the creator of the beast. thanks

The SQL you posted is pulling data from one table and only one field -
ClassDateStart.
For a 'complex' form you just gotta have more than that as source for the
form.
Open the form in design view, click on menu VIEW - Properties. Read what it
says for Record Source.
--
KARL DEWEY
Build a little - Test a little

this is all it says for the SQL:
SELECT DISTINCT Year([ClassDateStart]) AS Expr1
FROM tblClasses;

sorry, I am a novice with Access

Post the SQL of the query you are using as source for the form.
--
KARL DEWEY
Build a little - Test a little


:

Hey Karl, thanks for getting back to me! It isn't pulling any data even
though I know for a fact there is data under the dates inputted. I did try
text boxes as well, same results. Kind of hard to explain without you
actually seeing the form.

:

Everytime I try to add these boxes though they do not work. What am I
doing wrong?
Exactly what is the results? No records, wrong records, error message, etc.?

Try using textboxes to enter the start and end dates.
--
KARL DEWEY
Build a little - Test a little


:

I am working with an existing database. The form is pretty complex and pulls
from several different tables. One section states Years to Display and they
currently have it set up to just display one year. I want to make list boxes
that state Start Date (mm/dd/yy) and End Date (mm/dd/yy) to display more
information. Everytime I try to add these boxes though they do not work.
What am I doing wrong?

 

[KARL DEWEY]

Even when I click on properties it doesn't tell me anything.
I am not sure you are looking in the right place.
When you click on properties it opens another window. What does it says for
Record Source?

--
KARL DEWEY
Build a little - Test a little

Karl,
Thank you for your help. You are right, it is pretty complex and makes no
sense. Even when I click on properties it doesn't tell me anything. So I am
going back to the creator of the beast. thanks

The form is pretty complex and pulls from several different tables.

The SQL you posted is pulling data from one table and only one field -
ClassDateStart.
For a 'complex' form you just gotta have more than that as source for the
form.
Open the form in design view, click on menu VIEW - Properties. Read what it
says for Record Source.
--
KARL DEWEY
Build a little - Test a little

this is all it says for the SQL:
SELECT DISTINCT Year([ClassDateStart]) AS Expr1
FROM tblClasses;

sorry, I am a novice with Access

:

Post the SQL of the query you are using as source for the form.
--
KARL DEWEY
Build a little - Test a little


:

Hey Karl, thanks for getting back to me! It isn't pulling any data even
though I know for a fact there is data under the dates inputted. I did try
text boxes as well, same results. Kind of hard to explain without you
actually seeing the form.

:

Everytime I try to add these boxes though they do not work. What am I
doing wrong?
Exactly what is the results? No records, wrong records, error message, etc.?

Try using textboxes to enter the start and end dates.
--
KARL DEWEY
Build a little - Test a little


:

I am working with an existing database. The form is pretty complex and pulls
from several different tables. One section states Years to Display and they
currently have it set up to just display one year. I want to make list boxes
that state Start Date (mm/dd/yy) and End Date (mm/dd/yy) to display more
information. Everytime I try to add these boxes though they do not work.
What am I doing wrong?