Multiple Sub form Problem

[ckerns]

I have a main form with two subforms. Main form: parts first subform:
items quoted (form in continuous view).

I would like to click in row in first subform (quoted item) and have a
second subform (current prices) appear in main form.

My ultimate goal is then to click a new price box in second subform
and have it update the item in the first subform.

TIA

 

[boblarson]

You should probably use a listbox instead of a subform for selecting your
item.

 

[Mike Painter]

I think help has an example of this, the Northwind database does, thre are a
lot of examples on the web and almost any book on Access will have a way or
two.
Basically in the onclick event for the first form you want to set the
recordsource for the second.
One way is to have the key for the second forms data be kept in a hidden
field from the first form (=Forms![client company]!classes.Form!classid)
A master child relationship is set between the main form and the second
subform with this field.
No "clicking" is needed.