main form record from subform

[TC]

You would not normally use a subform to list the records available on the
main form.

You would normally use a listbox or combobox control on the *main* form, to
list those records.

The normal purpose of a subform, is to list the records from some other
table, that are related to the current record in the main form. (Eg. main
form = invoice header, subform = invoice lines).

HTH,
TC

 

[John]

Hello
I have a subform (continuous) on a main form that
provides a listing of all the records placed on the main
form. The subform listing also shows several other
fields along with dates. Eventually, there will be 100's
of records listed in decending order by date. What I
have attempted to do is place a small button next to the
continuous row on the subform so that the user can scan
down the list and when they see what they are looking
for, they click the button and the main form goes to that
record. The main form then shows the full record not
selected parts like what is in the subform. I keep
running into errors regardless of what I try.
Can this be done and if so point me in the right
direction.
Many thanks for any assistance.
*** John