linking a filtered subform

[socasteel21 via AccessMonster.com]

I have a subform that is filtered by a combo box on my main form. The combo
box is called cmbModelNumber. There is a Model field in the query which the
subform is based on. Therefore, I have put the two model fields from each of
the two forms in the Parent/Child properties of the subform. However, this
only provides me with a filter.

I would also like to link the main form to the subform. When I add tables
and relationships to the underlying query, the subform becomes inoperable. I
am trying to get my "ID" field from my main form into the query so I can link
the two forms together.

Can anyone help?

Thanks in advance.

Shannan

 

[pietlinden]

It sounds like you're filtering the subform using joins, which are
rendering the subform's recordset non-updateable. what if you used
EXISTS to filter the subform instead of inner joins?

 

[socasteel21 via AccessMonster.com]

I'm not 100% sure what you mean.

For short, this is what I want:

On the main form the user chooses a model number with a combo box. After
doing so a list of options for that model is displayed in the subform. The
user can then click the check box on each row of the subform for the options
he/she wants.

Is a subform even the right approach? I'm not sure. Thanks for your help.

Shannan

 

[pietlinden]

Checkboxes? I only use checkboxes when I have a real true/false field.
For choosing stuff, I can't think of a reason to use it. Can't you
use a combobox in a continuous subform?

if you use inner joins on the subform's recordsource, you're likely to
end up with recordset that is not updateable.

What's in the subform?

 

[J. Goddard]

Sounds like the underlying query of the sub-form is not updatable.

John

 

[socasteel21 via AccessMonster.com]

This is a real true/false situation...Is it not? I have just given the user
the option of choosing which options he/she wants on his/her machine.

Thanks for your reply.

Shannan

 

[socasteel21 via AccessMonster.com]

The subform contains, at the moment, an unbound text box that I have set to
the ID from the main form plus information such as OptionID, Description of
the option, and price. It also has the checkbox that allows the user to
select the option(s) he/she wants.

I am viewing the subform in datasheet view. That allows the customer to see
all of the options together at once.

Shannan