Expert
Windows 7 
Access 2000
I like the setup of the form, but I am not seeing how if I input a price into the Price field it header it is not displaying or taking me to the product with that price. This set up works great for a small scale project as I can just scroll down and see prices, but if it grows exponentially, I am going to need a way to search for that one price I am needing. I want to be able to type in a price, and it take me to the product that is, or has been that price in the past.
Master of Nothing
Windows 2K Access 2000
There are hundreds of ways to design the forms. Here is one I threw together in about 15 minutes......
Expert
Windows 7 Access 2000
Is there a way to do the adding of new records, and the searching the input records all on one form?
Master of Nothing
Windows 2K Access 2000
You opened the search form, entered a price and clicked the big search button???Originally Posted by jo15765
Expert
Windows 7 Access 2000
the first database search feature wasnt working, but it is working in the 2nd. is there a way to search and enter data on the same form?
Master of Nothing
Windows 2K Access 2000
Yes, but there needs to be more done so that The date and price isn't accidentally changed......
(and I found I a couple of errors in the previous......but they are fixed..
)
Expert
Windows 7 Access 2000
oh i agree. i was going to add the code to the afterupdate() of the form, so that once the record was added me.productname.enabled ~ false and me.price1.enabled ~ false so that the user will only have the option to enter a new price, or search for products with a certan price point. Do you know of a way to add records and search off of the same form?
Last edited by jo15765; 12-23-2010 at 08:18 PM.
Multiple keywords search of multiple fields
Help with a search feature or combo box
Posting Permissions
Reply With Quote