Pull Info from Query

[QB]

I have a query that listing a $ amount for each project.

In my project form I need to display this value. What is the best way to do
this? A subform? VBA Programming? I then need to use the returned value in
a control on the main form. Is one approach better than another?

QB

 

[Mark Andrews]

You can use a subform or something like a listbox control. Probably a
subform.

Either one would let you use the data on the main form. If you need to
enter or change data then a subform.

Just link the subform to the main form.

Lots of examples of subforms and making references out there on the web.

Once you add the subform if you can't get it to work the way you want try
another post with the details of what you are trying to do with
(I then need to use the returned value in a control on the main form. )

HTH,
Mark
RPT Software
http://www.rptsoftware.com