Simple? display form-hlp plse

  • Thread starter Thread starter Junior
  • Start date Start date
J

Junior

Trying to create a form that displays all records matching a cbo selection
using a parameter query.
Form is continuous form bound to the query with unbound cbo in form header
and bound query fields in form Detail.
When i select from the cbo the detail allows me to enter a new record - BUT
i don't want to use form for data entry
ONLY to display records in the query that match the cbo selection.
what must i set to use the form only to display existing records??
BTW, the parameter query displays the proper records, but the Form does not
Thanks

Form1 cbo =
SELECT [tlkpOccupationCode].[OccCode], [tlkpOccupationCode].[OccTitle] FROM
tlkpOccupationCode;

Parameter query =
SELECT tlkpCLCode.ID, tlkpCLCode.Series, tlkpCLCode.Comp,
tlkpCLCode.Specialty, tlkpCLCode.DateAdded
FROM tlkpCLCode
WHERE (((tlkpCLCode.Series)=[Forms]![form1].[cboseries]));
 
Junior said:
Trying to create a form that displays all records matching a cbo selection
using a parameter query.
Form is continuous form bound to the query with unbound cbo in form header
and bound query fields in form Detail.
When i select from the cbo the detail allows me to enter a new record - BUT
i don't want to use form for data entry
ONLY to display records in the query that match the cbo selection.
what must i set to use the form only to display existing records??
BTW, the parameter query displays the proper records, but the Form does not
Thanks

Form1 cbo =
SELECT [tlkpOccupationCode].[OccCode], [tlkpOccupationCode].[OccTitle] FROM
tlkpOccupationCode;

Parameter query =
SELECT tlkpCLCode.ID, tlkpCLCode.Series, tlkpCLCode.Comp,
tlkpCLCode.Specialty, tlkpCLCode.DateAdded
FROM tlkpCLCode
WHERE (((tlkpCLCode.Series)=[Forms]![form1].[cboseries]));
Click to expand...


It sounds like you forgot to Requery the form (possibly in
the combo's AfterUpdate event?).

You can set the subform's AllowAdditions property to No to
prevent adding new records. If you don't the users to edit
the existing records, then set the AllowEdits and
AllowDeleions to No as well.
 
Back
Top