J
john
cant seem to find a clear example.
Ive skimmed maybe 20-30 books at Borders and Barnes and Noble.
Heres the basics. Theres a table with name , soc security number ,
etc
Table1
( fields)
Soc sec
Name
etc
Its indexed on Soc sec as that will be the lookup.
I have a contiunous form - header + forms below.
In the header are two text boxes to enter :
1) Soc Sec no
2) Date
After entering both , I want it to lookup /filter
all the records that match that soc sec no , between the date entered
and the next 10 records.
Ive created all the input and output forms and databases.
The first question -- it should be so easy to do its ridiculous. How
do you get it to lookup only those records that match the index - soc
sec no ?
The second --- of course Id like to add the criteria of date and the
next 10 records after that date but Im focused on the simple mechanics
of doing the soc sec match and filtering. Ive seen bits on filter by
selection , filter by form . There are slight mentions of it here and
there but then they say use this button interactively etc. I want it
permanently set up were you enter a soc sec number and it filters the
matches automatically. Do I have to use VBA? Is there no automatic
way to do this? What event do I choose to write the code to :
a) initialize the displays on the forms so they are blank.
b) lookup the soc sec after input - obviously some updating event
would trigger that lookup
Anyone know of an example of this somewhere? This should be so common
and simple but searching the net I cant find it.
Ive skimmed maybe 20-30 books at Borders and Barnes and Noble.
Heres the basics. Theres a table with name , soc security number ,
etc
Table1
( fields)
Soc sec
Name
etc
Its indexed on Soc sec as that will be the lookup.
I have a contiunous form - header + forms below.
In the header are two text boxes to enter :
1) Soc Sec no
2) Date
After entering both , I want it to lookup /filter
all the records that match that soc sec no , between the date entered
and the next 10 records.
Ive created all the input and output forms and databases.
The first question -- it should be so easy to do its ridiculous. How
do you get it to lookup only those records that match the index - soc
sec no ?
The second --- of course Id like to add the criteria of date and the
next 10 records after that date but Im focused on the simple mechanics
of doing the soc sec match and filtering. Ive seen bits on filter by
selection , filter by form . There are slight mentions of it here and
there but then they say use this button interactively etc. I want it
permanently set up were you enter a soc sec number and it filters the
matches automatically. Do I have to use VBA? Is there no automatic
way to do this? What event do I choose to write the code to :
a) initialize the displays on the forms so they are blank.
b) lookup the soc sec after input - obviously some updating event
would trigger that lookup
Anyone know of an example of this somewhere? This should be so common
and simple but searching the net I cant find it.