Diamond-Leopard
Registered User.
- Local time
- Today, 01:57
- Joined
- Oct 30, 2018
- Messages
- 26
Let me start by saying every time I post here I have done extensive research to the best of my incredibly limited ability and it is only when my ignorance is more superior then my luck do I feel the need to ask the Gurus at Access World. Mainly because I know my question will be hilariously simple for someone who knows what they are doing ( Or what indeed to look for when something doesn't work) Anywho, apology done here is my question.
I have a form and in that form I have a link to my Inventory table which stores all the information on all the products that I sell.
I have an Order Form which is where I place in the item Number and it populates all the information about that item before I enter more information such as the sale date and customer name etc.....
What I would like is when I type into a box (Product Source) I would like the form to look the word I have typed into the box and immediately return the number of times that word has appeared in another table.
Does that make sence?
So For example as I type into a text box I want another text box to pop up with a number, I want it to search a table for how many times that number exists and to produce the number in the text box. But the Order form I am working in is linked to the Orders table which is where all the data goes when I save the record.
In excell I would do something like
Sumif(Index(*Answer Array*,MATCH(*TextboxInput*,*LookupArray*,0)
Any help is greatly appreciated thank you x
I have a form and in that form I have a link to my Inventory table which stores all the information on all the products that I sell.
I have an Order Form which is where I place in the item Number and it populates all the information about that item before I enter more information such as the sale date and customer name etc.....
What I would like is when I type into a box (Product Source) I would like the form to look the word I have typed into the box and immediately return the number of times that word has appeared in another table.
Does that make sence?
So For example as I type into a text box I want another text box to pop up with a number, I want it to search a table for how many times that number exists and to produce the number in the text box. But the Order form I am working in is linked to the Orders table which is where all the data goes when I save the record.
In excell I would do something like
Sumif(Index(*Answer Array*,MATCH(*TextboxInput*,*LookupArray*,0)
Any help is greatly appreciated thank you x