Control Source Question

[Brando]

Greetings,
I have a search form with a list box that displays query results. Double clicking on a row in the list box opens a detail form with the detail of the selected record. The other way to get to a detail form is by clicking on a command button that displays the detail of each of the records in the query result, one by one.
The problem is that there are many more fields in the detail form than the query that is its' control source. Since the detail form displays an individual record, it seems like it should be able to go into the table and fetch the rest of the data. No?

 

[neileg]

If you only have apples and oranges in your bucket, you can't pull out bananas, even if the bananas are in the next bucket.

If you want more fields in the detail form, then either you add them into the original query, or you base the detail form on another query that uses the record id from the main form as a parameter.

 

[Brando]

A bit of a fruity reply, but thank you.