I have database which contains 2 fixed columns (Product Name and ID) and 6 other columns (Products Prices like Cost, Sale Price,...) which are to be updated with time with respect to each product.
It currently contains 700 products as rows and more products will be added in the future.
I want to create a form through which I am able to search these produts and view their prices and in future update the existing price of that product. Also, i want to link every update in the price with a date and maintain a record of changes in prices of that product.
I am not very familier with VBA and need help in figuring this out.