individual records in subforms

[George]

I have a subform set up with 4 fields. The first two fields are just data entry. The third field is a combo box where the user selects a specific location. The fourth field is based off of what location the user selects in the previous field. I have put in a parameter in the fourth field to show only the records that match the location in the previous field, however as I add new records if the user choses a different location than the previous one, then all of the fourth field values disappear in the previous records disappear. Is there a way to set a make subform records more individual so that my parameter only pertains to the current record

Thanks for your help.

 

[Rebecca Riordan]

You'll need to display the sub-form in single form view, not datasheet or
continuous, which is what it sounds like you have.

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

I have a subform set up with 4 fields. The first two fields are just data

entry. The third field is a combo box where the user selects a specific
location. The fourth field is based off of what location the user selects
in the previous field. I have put in a parameter in the fourth field to
show only the records that match the location in the previous field, however
as I add new records if the user choses a different location than the
previous one, then all of the fourth field values disappear in the previous
records disappear. Is there a way to set a make subform records more
individual so that my parameter only pertains to the current record.