A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Form based on a query



 
 
Thread Tools Display Modes
  #1  
Old February 17th, 2006, 05:02 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Form based on a query

The information on my form is based on query results. I would like some of
the info to be based on calculations from a table instead. It would be the
same table every time no matter what the query results are, but the
calculation results would be different. How would I get started with that?

  #2  
Old February 17th, 2006, 05:51 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Form based on a query

You have a couple of choices. One would be to put upbound text fields on the
form and use something like DLookUp to pull in the data.

You could also create a form from the other table's data and use it as a
subform on you main form. This subform would probably not be linked to the
main form.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Dino" wrote:

The information on my form is based on query results. I would like some of
the info to be based on calculations from a table instead. It would be the
same table every time no matter what the query results are, but the
calculation results would be different. How would I get started with that?

  #3  
Old February 17th, 2006, 07:15 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Form based on a query

Thanks Jerry, I will try that.

"Jerry Whittle" wrote:

You have a couple of choices. One would be to put upbound text fields on the
form and use something like DLookUp to pull in the data.

You could also create a form from the other table's data and use it as a
subform on you main form. This subform would probably not be linked to the
main form.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Dino" wrote:

The information on my form is based on query results. I would like some of
the info to be based on calculations from a table instead. It would be the
same table every time no matter what the query results are, but the
calculation results would be different. How would I get started with that?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Move feild entries from form to form using global variables JackCGW General Discussion 11 November 14th, 2005 06:22 AM
Design help, please SillySally Using Forms 27 March 6th, 2005 05:11 AM
Union Query Not Returning A Value Jeff G Running & Setting Up Queries 2 October 19th, 2004 05:47 PM
Big number gives error! Sara Mellen Running & Setting Up Queries 8 October 11th, 2004 02:48 AM
Report Based Upon Parameter Query with Form References Vincent DeLuca Setting Up & Running Reports 4 July 19th, 2004 01:55 AM


All times are GMT +1. The time now is 11:24 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.