Subquery - Microsoft Access Forum - Computer Learning Zone


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Subquery

Giovanni Sada

16 months ago

I'm developing a large project and on one form, made of a main form with a table as data source and a subform with a query as data source. So far so good but now I need to perform calculations on my main form whe I change values in my subform. I'm not sure if is better to use VBA, where I consider myself a very advanced user (my mentor has beeen Rob Bovey), or a subquery. I've found many videos on subquery but not well explained and without any pros and cons of using a subquery, and you do not have any.
Regards
Giovanni

	Richard Rost @Reply 16 months ago
You're going to somehow trigger that recalculation, so you'll likely need a little VBA, but without a lot more specifics and some screenshots, I can't be more specific.

	Giovanni Sada OP @Reply 16 months ago
Thanks Richard I've solved my issue with some SQL. At the moment I'm trying to keep my VBA small as my goal is to make my project web based. Regards

	Richard Rost @Reply 16 months ago
You can still use MOST of your VBA on the web. ASP is very similar to VBA. That's what I use. There are some minor tweaks here and there, but it's very compatible.

	Giovanni Sada OP @Reply 16 months ago
Thanks good to know

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View