1 ADOC control-name "ADOC1" bound to msAccess called "MyData.mdb" Table called "MyTable"
1 TEXT box bound to "ADOC1" Field from MyTable called "fldNumber"
I have more textboxes but the one stated is involved in this question
Contains three MSFlexgrids
Also Another msAccess mdb called "Storage.mdb"
To a table called "MyStorage" is involved.
MyStorage structure is
All text fields
WHAT I NEED TO HAPPEN:
A person types a value into the textbox "fldNumber"(frmMain)
This value is passed to a table in the second mdb called
"Storage.mdb to a table called MyStorage and to the field
If there is a match The MSFlexGrids return the following:
MSFlexgrid1 returns the fields
MSFlexgrid2 returns the field
MSFlexgrid3 returns the fields
All from the "MyStorage" table
Things I'am pondering:
1.Bind the MSFlexgrids to an ADOC control
2. I cannot add a seperate field to type the search string because this would be redundant.
3. I have used the standard combobox search to MSFlexgrid type of routine, but I know * searching will be likely involved.
4. Add an ADOC control but do not bind to MSFlexgrids.
Any help with code would be appreciated.