Record invisible & open form when clicking record

[BlueStarBrite]

I have a form that contains a subform. Basically it is setup as a Waiting List. So I have a list of id's on the subform with some other information. What I need to know is the following:

1) When I no longer want an id on the waiting list (but I dont want to delete it from the database), how do I make it not visible to the waiting list subform? I have created a yes/no 'Inactive' field that I can toggle by a check box. Just not sure how to actually make the record invisible.

2. I want to click on a record in the waiting list and open a form that contains that record's information. How would I go about doing this?

Thanks in advance

 

[John Big Booty]

I have a form that contains a subform. Basically it is setup as a Waiting List. So I have a list of id's on the subform with some other information. What I need to know is the following:

1) When I no longer want an id on the waiting list (but I dont want to delete it from the database), how do I make it not visible to the waiting list subform? I have created a yes/no 'Inactive' field that I can toggle by a check box. Just not sure how to actually make the record invisible.

........

You could simply filter out records flagged (with you yes/no) as inactive. You could use a select query to do this and use it as the data source for you sub form.

....

2. I want to click on a record in the waiting list and open a form that contains that record's information. How would I go about doing this?

Thanks in advance

You could use something like the following behind the OnDoubleClick event;

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "FRM_YourFormName"    [COLOR="Green"]'Name of the form you want to open to show the selected line[/COLOR]
    
    stLinkCriteria = "[LinkID]=" & Me![LinkID]   [COLOR="Green"]'Replace [B]LinkID[/B] with the field that will allow the current line to be uniquely identified.[/COLOR]
    DoCmd.OpenForm stDocName, , , stLinkCriteria

 

[BlueStarBrite]

Thanks! That worked perfectly