Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-28-2012, 04:20 AM   #1
carrybag93
Newly Registered User
 
Join Date: May 2012
Posts: 73
Thanks: 21
Thanked 0 Times in 0 Posts
carrybag93 is on a distinguished road
Question Queries into forms without turning into a sub-form?

I've made a query that is supposed to be fully disfunctional, I just want it to display data. But when I drag it into my form, it creates a sub-form (or form, I'm not sure) and places that there instead. All I want is data from another table to be viewed in my form for another table.



e.g. I want the 'Order' form to display information from the 'Product' table to assist the user filling out the 'Order' form.

Any ideas?

carrybag93 is offline   Reply With Quote
Old 05-28-2012, 04:45 AM   #2
rodmc
Newly Registered User
 
Join Date: Apr 2010
Location: Caledonia
Posts: 515
Thanks: 14
Thanked 32 Times in 32 Posts
rodmc is on a distinguished road
Re: Queries into forms without turning into a sub-form?

eh, not sure im following you but thats whats supposed to happen, do these 2 tables form a one to many relationship?
rodmc is offline   Reply With Quote
Old 05-28-2012, 04:46 AM   #3
bob fitz
Newly Registered User
 
Join Date: May 2011
Location: Essex England
Posts: 3,478
Thanks: 50
Thanked 675 Times in 659 Posts
bob fitz has a spectacular aura about bob fitz has a spectacular aura about bob fitz has a spectacular aura about
Re: Queries into forms without turning into a sub-form?

Perhaps a Combo box or List box control, based on the query would be of use in this situation.

__________________
Bob Fitzpatrick
Microsoft Community Contributor Award (2011)
If this helped, please click the scales at the bottom left of this posting.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Many thanks.


I have never failed. I have found a thousand ways that do not work!
bob fitz is offline   Reply With Quote
Old 05-28-2012, 04:49 AM   #4
carrybag93
Newly Registered User
 
Join Date: May 2012
Posts: 73
Thanks: 21
Thanked 0 Times in 0 Posts
carrybag93 is on a distinguished road
Re: Queries into forms without turning into a sub-form?

rodmc: I don't want them to interact with each other, I just want an up-datable display of data gotten from one table to just be displayed in another table's form to assist the user filling out the form.

bob fitz: I don't know what you mean :s
carrybag93 is offline   Reply With Quote
Old 05-28-2012, 05:06 AM   #5
bob fitz
Newly Registered User
 
Join Date: May 2011
Location: Essex England
Posts: 3,478
Thanks: 50
Thanked 675 Times in 659 Posts
bob fitz has a spectacular aura about bob fitz has a spectacular aura about bob fitz has a spectacular aura about
Re: Queries into forms without turning into a sub-form?

Open the form in design view. Use the wizard to create a new Combo box or List box. When required, select the name of the query from the list of tables and queries. Give it a try. You can always delete the control if it is not what you need.
__________________
Bob Fitzpatrick
Microsoft Community Contributor Award (2011)
If this helped, please click the scales at the bottom left of this posting.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Many thanks.


I have never failed. I have found a thousand ways that do not work!
bob fitz is offline   Reply With Quote
The Following User Says Thank You to bob fitz For This Useful Post:
carrybag93 (05-28-2012)
Old 05-28-2012, 05:24 AM   #6
carrybag93
Newly Registered User
 
Join Date: May 2012
Posts: 73
Thanks: 21
Thanked 0 Times in 0 Posts
carrybag93 is on a distinguished road
Re: Queries into forms without turning into a sub-form?

Thanks for that solution! Is there any way to make the list box so that the user cannot actually select anything?
carrybag93 is offline   Reply With Quote
Old 05-28-2012, 06:57 AM   #7
bob fitz
Newly Registered User
 
Join Date: May 2011
Location: Essex England
Posts: 3,478
Thanks: 50
Thanked 675 Times in 659 Posts
bob fitz has a spectacular aura about bob fitz has a spectacular aura about bob fitz has a spectacular aura about
Re: Queries into forms without turning into a sub-form?

You could try setting its Locked property to Yes. This may give the effect that you want.

__________________
Bob Fitzpatrick
Microsoft Community Contributor Award (2011)
If this helped, please click the scales at the bottom left of this posting.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Many thanks.


I have never failed. I have found a thousand ways that do not work!
bob fitz is offline   Reply With Quote
The Following User Says Thank You to bob fitz For This Useful Post:
carrybag93 (05-28-2012)
Old 05-28-2012, 07:02 AM   #8
carrybag93
Newly Registered User
 
Join Date: May 2012
Posts: 73
Thanks: 21
Thanked 0 Times in 0 Posts
carrybag93 is on a distinguished road
Re: Queries into forms without turning into a sub-form?

Yep, it worked
Thanks very much!

carrybag93 is offline   Reply With Quote
Reply

Tags
form , import , query , relationship

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Issue with turning crosstab into form rainman89 Queries 1 11-09-2010 11:08 AM
Forms/Queries - Crosstab Query for dynamic form months valverde311 Forms 1 06-28-2010 11:03 PM
Turning a multi-value field into an edible sub-form milehighfreak Tables 1 12-20-2009 12:19 AM
Turning Off Filters on a Form bmcgree1 Forms 3 08-07-2009 08:01 AM
Open forms & queries from Maximized form aldeb Forms 8 03-04-2008 05:41 AM




All times are GMT -8. The time now is 12:58 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