Hi everyone
I want to open a form a subform based on a value assigned to openargs. The new form have a listbox with a select statement to filter the records based on the openargs value. The field value to pass is BirthDdate.
I want to open a form a subform based on a value assigned to openargs. The new form have a listbox with a select statement to filter the records based on the openargs value. The field value to pass is BirthDdate.
Code:
SELECT qryDogs3.DogID, qryDogs3.[Puppy Name], qryDogs3.BirthDate, qryDogs3.Mother, qryDogs3.PuppyNumber, qryDogs3.Location, qryDogs3.LocationID FROM qryDogs3 WHERE (((qryDogs3.LocationID)=3)) ORDER BY qryDogs3.Mother, qryDogs3.PuppyNumber;