Search form

[ScottXe]

I am working on a Search Form. Firstly I built a search query and built a search form with data sheet layout. They work correctly. I am struggling to add a feature that when I click a record, it should pop up a new form displaying the detail of that record. Can someone give me guidance how to add this feature.

[June7]

Not all the record info is shown on the datasheet form? Have you considered the Split Form design?

Or is this 'detail' data from a related child table? Then have you considered form/subform arrangement?

[ScottXe]

No all the record info appears on the data sheet form. However, the users prefer to view/edit a record in Tabular form.

[June7]

If the Split form is not acceptable, then use code like:

DoCmd.OpenForm "formname", , , "ID=" & Me.ID

The trick is figuring out what event to put the code in. Could be a button Click event.

[ScottXe]

I tried the code in click event. After I clicked the row, it showed up there was compilation error highlighting Me.ID. Any possible mis-match?

[June7]

Maybe, I don't know your form or field or control names so my example is generic. Use your actual names.

[ScottXe]

Thanks June7!