Open Form to Blank Record 1

[MeldrethMan]

The form I want to open to a blank record displays data collected in an earlier activity booking form that builds records in tblBookings containing names and Activity.

The new confirmation form uses tblBookings as source and there's an unbound 'Find Activity' combo using as source all unique Activities from the same table.

A subform displays all the people who have booked, with the Activity as linking field.

When the confirmation form opens the combo is naturally empty but the subform shows people on the first Activity in tblBookings.

How can I stop this?

 

[PHV]

with the Activity as linking field
Link it to the combo.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MeldrethMan]

Thanks PHV, just what I needed. Didn't even think of that.