How do I change the query my form uses?

[LanaDana]

Hi everyone,

I have a form that I spent a very long time formating to look nice and pretty. Well, low and behold, a bunch of data changed and I had to make a new table. Before I had a bunch of table and queeried lot the info I wanted. When the additional data came my way, I decided to dump everything into excel, combine the 7 tables into one. But now I have this wonderful form for data entry but it is attached to the old query. How can I change the query the form pulls from? I hope I am making sense here.

Also, I have another table that I pulled in as alink table (another dept's data). How can I incorporate that one in so when they update their data, my access data is updated too. Is that a subform? Or what, and how do I use it?

Thanks in advance,
Lana

 

[HiTechCoach]

How can I change the query the form pulls from?

Use the form's Record Source property (on the Data tab) to select a different query.

 

[dkinley]

You need to go to the form properties. Open the form in design view, right click anywhere and open the properties screen. In the drop down box of the properties, select Form.

Click the Data tab. The first row is Record Source. Use this drop down box to select the query you would like to use.

Hope that helps,
-dK

 

[James Dudden]

Hi,
To change the query the form pulls from you need to change it's properties to do this, open the forms properties panel and on the data tab you can select the recordsource to use

 

[LanaDana]

Thanks! Changed the record source to the new data.

HOWEVER, now there are no records in the form. Do I now need to go thru each item and change using the field list? Or is there another way to do it? A better way to now update each seperate item in the form?

Don't know if it matters, but I am using Access 2000. (yes, I know...its like clicking stones together. We are in the dark ages around here!)

 

[dkinley]

If you end up with unbound controls, then yes - you will need to set each control to the field in the query by use of the control properties and data source.

-dK

 

[LanaDana]

If you end up with unbound controls, then yes - you will need to set each control to the field in the query by use of the control properties and data source.

-dK

Thanks DK! I was just making sure I wasn't leave something out or missing a step somewhere. I am trying to learn access by teaching myself. I have the Access 2000 Bible, but if you dont know exactly how to ask the question, you can't find the answer! but I am learning.

Thanks to all of you pioneers!

 

[dkinley]

Very, very true.

Here is some more resources for ya ...

http://www.techonthenet.com/access/index.php
http://www.functionx.com/vbaccess/

Good luck with your project!

-dK

 

[LanaDana]

Thanks!!!!!!!!!!!!!

Here is some more resources for ya ...

http://www.techonthenet.com/access/index.php
http://www.functionx.com/vbaccess/

Good luck with your project!

-dK

Nice ones! Lots of info in good user friendly layout! Thanks!