I am having problems with a form with a subform I have created. I think I must be being really dumb but can anyone help me please. With the database the two tables that I am using are one called Owner and one called Pet. I want a form with the owner details are the top: OwnerID, FName,Surname, Address, TelNo and VetID(PK in another table). Below in the subform I have the Pet table PetID, name, category, dob.
I can create the form with subform and show all records and make a new record. But as soon as a create a combo box (using wizard) to look up details based on the surname in the owners table, I can now longer create a new record.
Is it possible to look up records in the form by using a combo box on surname and also still create a new record if I want?
Any help would be greatly appreciated.
I can create the form with subform and show all records and make a new record. But as soon as a create a combo box (using wizard) to look up details based on the surname in the owners table, I can now longer create a new record.
Is it possible to look up records in the form by using a combo box on surname and also still create a new record if I want?
Any help would be greatly appreciated.
