Type Mismatch in Expression

[Nipesh]

I have one table as tblbuyers and other table as tbl status

I am trying to Make a Form with combo box so when form is entered it will give the status of the Buyer as to what stage he is in to. I have attached file for your review.

I am trying to make a query so I can merge status to show in combo box of the form let me know if i am wrong.

SELECT tblBuyers.Name, tblBuyers.Date, tblStatus.Status
FROM tblBuyers INNER JOIN tblStatus ON tblBuyers.Status = tblStatus.ID;

Thank you for your help, need urgent if pro can get this cleared

 

[Galaxiom]

I have not looked at the databse but the Join criteria looks unlikely to me.

Also note that Name and Date are both reserved words.

You would need to at least surround them in square brackets but you are better off with alternative names for your fields.

 

[Nipesh]

I am working on it will rectify that