After search, open a form, scrollbar & Min botton disappears.

[ychousa]

Hi. I have a search form with a result listbox. By double clicking an item in the listbox, the main form opens. My problem is that the opened form doesn't have a scroll bar or minimize button.

In the form property, they are set to show up, and when I open the form directly, they appear, but by searching through my search form, they don't.

Here are some of the codes that might be helpful.

Listbox Code(inside search form) to open a main form:
Private Sub SearchList_DblClick(Cancel As Integer)

Dim Criteria As String
Dim CurDB As Database

DoCmd.OpenForm "frmMain", , , , , acDialog

End Sub

On Formload event of a main form:
Private Sub Form_Load()
Dim rs As DAO.Recordset

Set rs = Me.Recordset.Clone
'rs.FindFirst "[DetID] = " & Forms!frmSearchForm!SearchList.Column(4)
rs.FindFirst "[DetID] = " & Forms!frmSearchForm!SearchList.Column(4)

If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Set rs = Nothing
End Sub

How would I make them appear?

 

[ychousa]

I found an answer in another source. I'm posting this for other members.

The problem was acDialog in DoCmd in my listbox. I changed it to stLinkCriteria, and it worked.