Subform Problem

  • Thread starter Thread starter GB
  • Start date Start date
G

GB

(This is a very basic problem but I have no idea, tried searching all over
for help!!!)

Help!

I have an order entry dB that allows me to enter multiple items per order.

From the main form I can see all quotes entered by Customer, by selecting
one of those quotes and then clicking on 'View Quote' I access a form named
[Orders].

Problem...

On this form I have two subforms - [x] (default view = single form) and [y]
(default view = datasheet), the idea is that I enter the order items in [x]
and these should appear in [y].

I don't know how to link the two together, I'd like to be able to click in
[y] and see all the relevant info in [x].

I've tried linking the OrderDetailID as the Child and the OrderID as the
Master but no combination seems to work.... Any ideas greatly appreciated.

G
 
G, I think you are working with a very interesting
problem. I really wish I could help you but I never used
Access. You sound like a very determined person so I think
you'll crack this problem. Wishing you a lot of luck,
don't give up, man!
 
The link properties work only between a main form and a subform. You can
"trick" the system by putting an invisible textbox on the main form and
setting its control source to be an expression that reads the desired
control on the subform, and then using this invisible textbox as the
"Master" link for the second subform, but that shouldn't be necessary here.

Assuming that the y subform is simply to display the selected items, set the
recordsource of that subform to be a query that reads the records that
you've entered/selected on the x subform, and then run code on an event for
the x subform (perhaps the form's AfterUpdate event) that requeries the y
subform's Recordsource.
 
Back
Top