I am sharing the database as .rar file.
'tblCust' contains information about the customers - Name, Age, Address, Contact, Date of entry and serial number. 'frmCust' is used by user to add information to 'tblCust'. 'frmSearch' contains two text-boxes which are to be filled with date of entry and serial number by the user. A button is given to run a query ('qrySearch') which takes in inputs fron both of the above boxes, and generates all the records of that individual customer. There will be only one customer with a serial number on a given date, so the result of 'qrySearch' will always have one record.
All I want is the text-boxes to be filled, i.e. to show the records of name, age, address and contact once the records match according to date and serial.
I have tried to set the record source of the form to 'qrySearch' and control sources of the text-boxes to their respective controls, but it is not working.
I am really new at this and perhaps making some really trivial mistake, please help me through this. Any help would be greatly appreciated.
'tblCust' contains information about the customers - Name, Age, Address, Contact, Date of entry and serial number. 'frmCust' is used by user to add information to 'tblCust'. 'frmSearch' contains two text-boxes which are to be filled with date of entry and serial number by the user. A button is given to run a query ('qrySearch') which takes in inputs fron both of the above boxes, and generates all the records of that individual customer. There will be only one customer with a serial number on a given date, so the result of 'qrySearch' will always have one record.
All I want is the text-boxes to be filled, i.e. to show the records of name, age, address and contact once the records match according to date and serial.
I have tried to set the record source of the form to 'qrySearch' and control sources of the text-boxes to their respective controls, but it is not working.
I am really new at this and perhaps making some really trivial mistake, please help me through this. Any help would be greatly appreciated.