Pull Info from Query

Q

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using an append query in a subform 1
Copy data from 1 subform to another subform 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
filtering a form based on the values of a subform 0
Main Form with Subforms 5
Repost from 6/18: New record in subform for info on main form 2
Pause Subform 1
Update table from unbound field in form 1

Top