Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-15-2019, 05:01 AM   #16
norburao01
Newly Registered User
 
Join Date: Jul 2019
Posts: 12
Thanks: 4
Thanked 0 Times in 0 Posts
norburao01 is on a distinguished road
Re: How to reference a value from a query in a form

Thank you for the help @arnelgp and jdraw.

I will post a copy of the database so its easier for you to see how I would like the format of the form.

On the 'Component in detail review' (the form) I would like it to show the overall cost as a value (box in there its just unassigned at the moment). Another important point is that I want to edit the values in the form.

If you think remaking the Form using Query previously mentioned as the record source. Adding the data from the Components list will work the best I will do this. (@arnelgp's method). But if there is better way you can think of that will work for this format I will do that.
I have tried remaking the form using the query but I am unable to edit the values shown so would need advice on how to overcome this.
Also I would not be editing the overall cost, I would be editing the two sub costs (Additional costs and Price (from the two tables Component list and Common products list respectively)
Attached Files
File Type: zip Interface Database Small.zip (49.8 KB, 4 views)


Last edited by norburao01; 08-15-2019 at 05:54 AM.
norburao01 is offline   Reply With Quote
Old 08-15-2019, 06:26 AM   #17
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 7,595
Thanks: 59
Thanked 2,435 Times in 2,335 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: How to reference a value from a query in a form

here take a look at the new query, see the recordsource of the form in design view.
the the overall cost on the form.
Attached Files
File Type: zip Interface Database Small.zip (48.8 KB, 2 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is online now   Reply With Quote
Old 08-15-2019, 06:48 AM   #18
norburao01
Newly Registered User
 
Join Date: Jul 2019
Posts: 12
Thanks: 4
Thanked 0 Times in 0 Posts
norburao01 is on a distinguished road
Re: How to reference a value from a query in a form

@arnelgp I've had a look at the form and I cannot edit or add new data.
I need to be able to edit from the form, is this because its recordsource is from a query?

norburao01 is offline   Reply With Quote
Old 08-15-2019, 07:08 AM   #19
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 7,595
Thanks: 59
Thanked 2,435 Times in 2,335 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: How to reference a value from a query in a form

here I change it to dlookup.
it's updateable now.
Attached Files
File Type: zip Interface Database Small.zip (48.2 KB, 2 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is online now   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
norburao01 (08-15-2019)
Old 08-15-2019, 07:36 AM   #20
norburao01
Newly Registered User
 
Join Date: Jul 2019
Posts: 12
Thanks: 4
Thanked 0 Times in 0 Posts
norburao01 is on a distinguished road
Re: How to reference a value from a query in a form

Thank you @arnelgp you have been very patient and helpful.
Thats everything sorted
norburao01 is offline   Reply With Quote
Old 08-15-2019, 07:52 AM   #21
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 7,595
Thanks: 59
Thanked 2,435 Times in 2,335 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: How to reference a value from a query in a form

you're welcome!

__________________
"Never stop learning, because life never stops teaching"
arnelgp is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to reference control on Main form from query Lateral Forms 4 08-14-2016 08:09 PM
Reference text field from form in a query cjmitton Forms 17 09-30-2011 08:29 AM
Reference to main form in append query Lady Gragor Queries 11 11-27-2008 08:08 PM
How do I reference a value on a query on a form is not sourced from the same query? ST4RCUTTER Forms 2 05-29-2008 09:16 PM
Query reference a form control Access / SQL detrie SQL Server 7 09-06-2007 01:13 PM




All times are GMT -8. The time now is 01:22 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World