Form Controls

[Guest]

I have a form and a subform [SS]. has a control source of table [S
Models], [SS] has a control source of a query [SSQry] which takes the values
from table [SSD].

QRY
Customer Product Price Quantity
[SSD] [SSD] [Prices] [Prices] from where

SS Details
Customer Product Price Quantity

When I fill in the form the data is stored in the query accurately, filling
in all columns. However, I can't get the price and quantity to be filled in
in the SS Details table. I know it kind of complicated but I'm pretty
stumped. What should I do?

 

[strive4peace]

base your SS form directly on the SSD table (form RecordSource property)
so all fields show

Make sure the ControlSource property of all fields that need come from
and/or go to the table are filled with a field from the RecordSource

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[strive4peace]

Can you specify your table structures and how you want to limit the records?

When you say that you want price and quantity to be filled... Price, I
assume is a lookup -- and the user specifies quantity?

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

That's the issue though, I don't want all the records to show...that's why I
had to get complicated and do it via a query. So, I'm still having issues.

base your SS form directly on the SSD table (form RecordSource property)
so all fields show

Make sure the ControlSource property of all fields that need come from
and/or go to the table are filled with a field from the RecordSource

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

I have a form and a subform [SS]. has a control source of table [S
Models], [SS] has a control source of a query [SSQry] which takes the values
from table [SSD].

QRY
Customer Product Price Quantity
[SSD] [SSD] [Prices] [Prices] from where

SS Details
Customer Product Price Quantity

When I fill in the form the data is stored in the query accurately, filling
in all columns. However, I can't get the price and quantity to be filled in
in the SS Details table. I know it kind of complicated but I'm pretty
stumped. What should I do?