Help with a list box

[deercreek]

I need some help figuring something out. I'm not sure if I heading in
the correct direction. What I'm trying to accomplish is the following.
I have a table that
has id, discrip, and 2 date fields. I am populating this information
from a sub from on a
main form. The Id and date fields are tied together in the forms. I am
trying to get the
descrip field to show up in my main form under a listbox. I have
created a sql query to try to accomplish this. I can have multiple
lines of information for each id. That's why I'm trying to show in
list box. The problem I am having is I cannot get it to look for
specific id of the current page I'm on in the form. It prompts me for
id. If I enter the id the list box displays correct info. I would like
for it to see what page I'm on in my form take the id from there and
fill the list box accordingly. When I change sheets it would
automatically update. I have pasted sql query below. I would really
appreciate any insight on how to make this work. Thanks ahead of time.
Dan
SELECT [reserve].[site], [reserve].[reservationid],
[reservations].[reservationsid]
FROM reserve
WHERE (([reserve].[reservationid])=([reservations].[reservationsid]));

[deercreek]

Still need a solution. Anyone?

[Tim Marshall]

deercreek wrote:

Still need a solution. Anyone?

Get rid of the single quotes TL was questioning.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[Thelma Lubkin]

deercreek <da*@deercreekc g.com> wrote:
: Still need a solution. Anyone?

Is it still prompting you for the ID? If it is, it seems that
one of the table or field names you've provided is wrong:I
recently spent a long time w/ something like that and finally
noticed that the capitalization that I was using for a field
name was different from what the table actually had for the name.

Otherwise try to print out the SQL statement you're actually
using. Maybe in the listbox's setfocus event, put a
debug.print of a string variable that you've set equal to the
the SQL statement: this should show you the statement with the
actual ID value that you're asking for instead of
control.value--is it what you think that you've given it?

--thelma, muddling along with you

[Jana]

Deercreek:

You can't just put quotes around the field like you have done. Take
out the quotes around the [Forms]![Taking
Reservations]!ReservationsID]:

SELECT [site]
FROM reserve
WHERE [reserve].[reservationid]=([Forms]![Taking
Reservations]![ReservationsID]);

[deercreek]

Below is the code Im using for query.
SELECT [site]
FROM reserve
WHERE ([reserve].[reservationid])=([Forms]![Taking
Reservations]![ReservationsID]);

It does not prompt me anymore what it does is it brings back the 1st
record set's information. but if I go
to the next record it gives me and pop-up ERROR
Saying : microsfoft access can not find Me!Lstsites.

Now someone else suggesting putting a requery statement in the form
under the "on current" command line and onthe reservationid "after
update " command line. The line is

Me!Lstsites.Req uery

Thats when the listbox actually started showing at least the first
record set untill then it was blank.

Thats were I'm at now.

[deercreek]

Thanks everyone I got it. requery need to go into code not just typed
in.

Thanks
Dan