Search results

Hi Paul Thank you for your assistance with this little problem. I understand the way the form should work now and I have managed to setup the Form to show the information I need. Thank you sir. Cheers Dave

Hi Paul Attached copy of the database. Cheers Dave

Hi Paul You are correct, the table which contains the Product details has two fields (ProductCode, ProductName). On the Form I have added the tblProduct.ProductCode field and the other fields from the tblDataEntry, then I have created a text box with the information you have supplied. When I...

Thanks for your suggestion. I have added the combo box onto a form - ProductNo. I have then created a Text Box and set the Control Source as you have said. When I try entering in different Product numbers using the combo box it does not enter any text into the text box. Cheers Dave

Hi, thanks in advance for any advice or support. I have an Access database with two tables: tblProducts tblDataEntry In the tblProducts table there are two fields ProductCode and ProductName. I would like to have a combo box on a form which contains the contents of the ProductCode field, and...