Using form control values in List Box rowsource select statements

D

David

Hi,

I have been finding solutions for programming problems in Google
Groups for a couple years now and have, for the first time, not been
able to find a discussion of the problem I am currently facing.
Perhaps someone out there can help me.

I have an Access 2000 form with a list box that displays data from two
joined tables. My rowsource property currently looks like:

SELECT [Hikers].[LastName], [Hikers].[FirstName],
[Participants].[HikeID], [Participants].[ID] FROM Hikers INNER JOIN
Participants ON [Hikers].[HikerID]=[Participants].[HikerID] WHERE
((([Participants].[HikeID])=Forms!Hikes!HikeID));

You may see what I am trying to do here. I am trying to reference the
value of another control on the form from within the select statement
that populates the list box.

This is not working. I have not been able to figure out how to
properly make this reference. Is it possible? Should I be doing this
in VBA somehow.

I'm a java web developer making my first attempt at an Access
application and would appreciate any help you can give me.

Thanks,

David
(e-mail address removed)

(take out the "NOSPAM" to respond to me.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Creating a Search using a combo box and then creating a report. 4
Dynamic Naming of Form Button 3
Using the list form control: multi-selection possible? 3
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
How to Select Multiple Emails using Surface Pen 0
Select field from table not used by form 6
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0

Top