Search Form Link

[Justns11]

Hi all,
I have just created a search form which when you type in a part number, it displays the part information, as well as steps required to create that part. My boss would also like the user of the search form to be able to click on the specific step (StepID) and view information on that step, either in a new window, or in the current form. The steps are sorted into different tables by the type of operation required for that step. If you look at the screenshots I've attached you will get a better understanding.

Basically I'd like to make it so you can click on the StepId in the table to the right on my form and view the specific information for that step. What I believe might cause a problem is that almost all of the tables that the step information is stored in contain a different # of fields, because the information they contain are all different.

Thank you in advance for the help, if you need any further information please feel free to ask.

 

[jsv2002]

Can't really tell from the image but have you filtered a selected table into a different view or are they a query?

In other words are A,B,C,D etc tables contained information on all processes that are filtered by selection...

If so actually viewing them may be a problem displaying information to end users is usually done by forms or reports filtered by a query.

EDIT:

That was a really hideously worded response will post back when my brain rejoins the living.....

 

[Justns11]

haha, no problem. Right now I just have a filtered table. The afterupdate code is as follows :

Sub CboPartNo_AfterUpdate()
Dim rs As DAO.Recordset

If Not IsNull(Me.cboPartNo) Then
'Save before move.
If Me.Dirty Then
Me.Dirty = False
End If
'Search in the clone set.
Set rs = Me.RecordsetClone
rs.FindFirst "[Part No] = """ & Me.cboPartNo & """"
If rs.NoMatch Then
MsgBox "Not found: filtered?"
Else
'Display the found record in the form.
Me.Bookmark = rs.Bookmark
End If
Set rs = Nothing
End If
End Sub

Private Sub cboPartNo_BeforeUpdate(Cancel As Integer)

End Sub

hope that helps.

 

[Justns11]

Another idea...could I create another combo box at the bottom of the form where the use selects the StepId and then hits enter and the details for that step would display either below or in a new window? Please any help would be great...I'm stuck and I need to get this to work...other ideas would help too.