B
Bandit
I need some help with a search form. I have been reading the posts on this
newsgroup for awhile now. Based on what I have read, I think
http://allenbrowne.com/ser-62.html is exactly what I need. Sad to say
though, as a beginner, I am at a loss to make it work for me. I have
designed the form much like the one in the instructions. I have taken the
code for Text and changed it to the name of my fields, etc. I tired doing one
criteria at a time. I think this is just too advanced for me. If someone
could help me with it, I would appreciate it and will probably have a better
understanding for next time if I see it adapted to my needs. My fields are:
ProductName-Text
ProductNumber-Text (the product number has letters and numbers so I chose
Text)
SerialNumber- Text (the serial number has letters and numbers so I chose Text)
Product Description- Text (a short written description of the product)
When the search is executed, I want the above fields to display as well as:
Location- Test (combo of numbers & letters)
Quantity-Number
I would like the user to be able to enter any one or combination of the
search fields to bring up the records. If the user just enters the product
name, there may be more then one product with the same name, so the user will
need to scroll through to find the correct product.
At some point, I am not sure if it should be on this form or not, I would
like to do an inventory calculation, if I can figure this out. When the user
enters the product name and the search displays the location and quantity, I
would like the user to be able to enter that he is taking three items off the
shelf and have the calculation update the on-hand quantity. I have reviewed
the inventory calculations on Allenbrowne.com. Right now, the important
thing is to do the search form. The calculation is sometime down the road
unless anyone has some better ideas.
Thanks
newsgroup for awhile now. Based on what I have read, I think
http://allenbrowne.com/ser-62.html is exactly what I need. Sad to say
though, as a beginner, I am at a loss to make it work for me. I have
designed the form much like the one in the instructions. I have taken the
code for Text and changed it to the name of my fields, etc. I tired doing one
criteria at a time. I think this is just too advanced for me. If someone
could help me with it, I would appreciate it and will probably have a better
understanding for next time if I see it adapted to my needs. My fields are:
ProductName-Text
ProductNumber-Text (the product number has letters and numbers so I chose
Text)
SerialNumber- Text (the serial number has letters and numbers so I chose Text)
Product Description- Text (a short written description of the product)
When the search is executed, I want the above fields to display as well as:
Location- Test (combo of numbers & letters)
Quantity-Number
I would like the user to be able to enter any one or combination of the
search fields to bring up the records. If the user just enters the product
name, there may be more then one product with the same name, so the user will
need to scroll through to find the correct product.
At some point, I am not sure if it should be on this form or not, I would
like to do an inventory calculation, if I can figure this out. When the user
enters the product name and the search displays the location and quantity, I
would like the user to be able to enter that he is taking three items off the
shelf and have the calculation update the on-hand quantity. I have reviewed
the inventory calculations on Allenbrowne.com. Right now, the important
thing is to do the search form. The calculation is sometime down the road
unless anyone has some better ideas.
Thanks