QuickQuestion - records

[Cindy]

No no, I dont want the form to 'filter' what they have
entered persay. Id just like the form to load (which
only has 1 record displayed) to go to the record that
matches the data in the listbox, thanks
Cindy

-----Original Message-----

-----Original Message-----
Hello,

I have a form that has a listbox that shows the data from
a table, id like to be able to click on an entry and
click a command button to open that record (as a form).
Whats the command to do this? thanks
.

Create a command button that has a filter built in.
Assuming that you have the second form built you should be
able to create the link with the command button wizard.
Here is the code that I use to open up a second form based
on the data in 1st. Like you have a limited (I post 3
peices of data, not one) on teh main form but want all the
data on the second, filtered, form.

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "fm_DATA_Detail"

stLinkCriteria = "[dataID]=" & Forms! [fm_DATA_limited]!
[dataID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

tht

Lee T.


.