I have a query that returns a single aggregate value based on the input
parameter. I can't figure out how to display this on a form. The parameter I
want to pass to the query is the primary key from the current record. Any
ideas on how I can do this automatically? Or is there a better way of getting the value, I used a query because it's a distinct count function.

Access::Student,

Please don't be offended but I can understand what you are trying to do;

If you create a "Single Form", with the control source being a query based on your data table. It will display each primary key record (you can't have duplicate primary keys).

Now if you want to locate a record quickly then you can add a combo box to the form (using the wizard and select option 3) and that will find the record that you want to view.

If I have missed the point, please ignore me.

__________________
Regards,

John A