Need help on seeing data in form

[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]));

[Thelma Lubkin]

deercreek <da*@deercreekcg.com> wrote:
: 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.
Set the rowsource property of your listbox to the main
form's id-field:

=Forms!yourformname![reservations].[reservationsid]

where yourformname is the name of your main form.
--thelma

: Dan

: SELECT [reserve].[site], [reserve].[reservationid],
: [reservations].[reservationsid]
: FROM reserve
: WHERE (([reserve].[reservationid])=([reservations].[reservationsid]));