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

[Steve]

Dan, I'm not sure I completely understand the situation you have, but I
will try to help with some general listbox information.

To populate a listbox that is bound to a table, you can simply add
records to the table and then call the ListBox.Refresh () method. This
may be useful if your listbox is on the main form but you want to
populate it from a subform. If you are doing many updates of the
listbox, this can have a lot of overhead.

You can also populate the listbox programmaticall y. One way is such:
Here, lstBox will indicate your listbox, and frmMain will indicate your
main form.

Forms!frmMain!l stBox.Items.Add ("info you want to add")

[GH]

In your query:

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

Is reservations the form name or is it supposed to be a field from a
joined table. I am not sure if this is your root problem or not, but
your query would give an error right now since the reservations tables
does not exist in the FROM clause. I would expect your query to look
more like:

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

OR

SELECT [reserve].[site], [reserve].[reservationid],
[reservations].[reservationsid]
FROM reserve INNER JOIN reservations
ON (([reserve].[reservationid])=([reservations].[reservationsid]));

Also, you really would not need to have two reservationid fields in the
result set, since they are equivalent.

Again, this may not be causing the issue with the list box, but it
might be contributing to it.

[deercreek]

Perhaps Im not making myself clear. I want a list box to show
information from a table in a form. The table is not the table that
main form is driving. I want the list box to see the reservationid from
the form on which ever record is active, and to show only the
information where the 2 reservation id's are =. The list box will work
if I type in reservationid, but it won't get it from the active form
page like I want. Hopefully this bettrer explains problem.

[pietlinden]

so base the listbox's rowsource on a query.

Listbox rowsource:
SELECT [Last] & ", " & [First] AS Contact
FROM olkContacts
WHERE (((olkContacts. City)=[Forms]![Form2]![Combo2]))
ORDER BY [Last] & ", " & [First];

except in your case, your WHERE clause would point to the control on
the form showing the reservationID. So your rowsource would be
something like:

SELECT [Last] & ", " & [First] AS Contact
FROM olkContacts
WHERE (((SomeTable.Re servationID=For ms![MyForm]![txtReservationI D]))
ORDER BY [Last] & ", " & [First];

[deercreek]

I have already tried this below. If I am following you you are saying
same thing.
It still won't update the listbox. Is my syntx incorrect?

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

[Thelma Lubkin]

deercreek <da*@deercreekc g.com> wrote:
: I have already tried this below. If I am following you you are saying
: same thing.
: It still won't update the listbox. Is my syntx incorrect?

: SELECT [site]
: FROM reserve
: WHERE [reserve].[reservationid]=('[Forms]![Taking
^
| what are those for? _________
\
: Reservations]![ReservationsID]'); \
^ \
|______________ _______________ ______\

[deercreek]

Are you asking about the reservationsid, Its the text box name that
holds info.

[Thelma Lubkin]

deercreek <da*@deercreekc g.com> wrote:
: Are you asking about the reservationsid, Its the text box name that
: holds info.

Do the quotes that mean that your ID is defined as a string?
I thought number which wouldn't need any quotes.
--thelma

[deercreek]

My id is set as a text field currently. I will create my own custom
info to occupie this field once I
get the form to work.