Selcted Record In Subform

[Guest]

Hi,
There are already several questions about finding selected record in a
subform, but nothing suit my needs, so I decided to post this question....

Right now I have one main form and one subform on it. The subform is base on
a query which (the query) controlled by combo box on the main form. (Every
time combo box change, the subform will requery).

I'm planning to add another subform (also base on a query) but instead of
controlled by a combo box, the third subform controlled by selected record on
the second subform. So each time I select a record on the second subform, the
third form should show corresponding data....

Thanks in advance.... Sorry if this already discussed before, if so, please
link me to the solution, really need to make this work....

BR,
RD

 

[Allen Browne]

Open the Northwind sample database, and take a peek at the Customer Orders
form.

Whenever Customer Orders Subform1 moves record, it loads the matching
records into Customer Orders Subform2.

 

[Guest]

I have basically three tables working for this form:
Table 1: baseID - baseName
Table 2: commodityID - commodityName
Table 3: ID - commodityID - baseID - price - sell(Yes/No)

On the main form I will pick the base, and the sub form 1 will show the list
of commodity which the base sell. What I want is when I pick a commodity from
subform 1 the subform 2 will show all prices and bases from the same
commodity so I can pick the most profitable trade route....

I already looked at the Northwind, problem is on my form the subforms are
unbound so i cannot set master/child link...

Thank you vary much for the instant reply, really appreciate it.... but
unfortunately still in the dark here....

Cheers,
RD

 

[Allen Browne]

Sorry, can't help.

I have no idea how to work with an unbound form that is based on a query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

[snip]

 

[Guest]

Sorry to waste your time again Allen, but I decided to change the second
subform into Listbox, and now already work...

But another question: when making a listbox, at the end of the wizard,
access should ask "which value should kept for later use..." (or something
like that), I wonder if my list box hold more than two fields (because
ussualy the two is ID and Name), can I also get the value from the field that
I didn't set from the wizard? (Let say in my list box I have ID - Name -
Price, ID already used to control the item of the subform, I want price also
filtering the subform, so subform only show item with price higher than I
selected at the listbox)

Thanks,
RD

Sorry, can't help.

I have no idea how to work with an unbound form that is based on a query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

[snip]

I already looked at the Northwind, problem is on my form the subforms are
unbound so i cannot set master/child link...