how do I get a datasheet results list to appear in a form?

[rebfein]

I created a simple query for my boss a year ago and who

now wants the results to appear in a form.



The query is set in a one (Model) to Many (ECOs pertaining to that model [ECO = Engineering Change Orders]) relationship.

What I want to do is create a form where he enters the model number and clicks a button (these I have set up) to search for the results.

What I can't get to work is the datasheet showing the search results as a list to appear on the form below the search information.

Any suggestions?



Many thanks,

[June7]

Put the search control in the Form Header section. Consider using a combobox instead of textbox. This control should be UNBOUND, otherwise data in record will be changed when user types/selects value.

Bind the form to the table or query. Put data controls in the Detail section.

Review http://allenbrowne.com/ser-62.html

[Peter M]

There are a couple of ways to accomplish this. To do it without any VBA code, make a Parent Form and Sub Form which are joined by Model Number

Data for your Parent/Main Form: qry_Models
Data source for your Child/SubForm: The query that joins Model to ECO (qry_Data)

Set the subform to be in datasheet mode or continuous mode to have a list of the ECOs

[June7]

Again, the 'search' control must be UNBOUND. Unless you want to use the intrinsic filter/search tools on the ribbon or right click shortcut. This means NOT typing or selecting value in BOUND control because that would change value in record.

[ssanfu]

I have used both methods, depending on who is using the form and what I want to display/search for. I tend to use the main/sub form arraignment because no code required (except for the close buttons).

I mostly use continuous forms view because I can control the control placement.

Here are 4 layouts for you to tear apart .....