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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Auto Fill
I have four tables which hold various pieces of data about
individial companies. The information in these tables changes and I use a query to pull all the info together to just look at the latest piece of info for a company. My problem is that I need to use this queried information in a data entry order form. When I select from a drop down the company name, I would like the queried info - four fields of data - to appear as a reference. Then have the order details entered thereafter. I cannot seem to get this to work. I tried to look at the info as subform - but you can't do continuos forms. I tried creating a table from the query but that didn't seem to work either. I think it's something simple but I'm having a total blank. Please help me! Sam |
#2
|
|||
|
|||
"Sam A" wrote in news:201501c4a790
: I have four tables which hold various pieces of data about individial companies. The information in these tables changes and I use a query to pull all the info together to just look at the latest piece of info for a company. I am not clear about the design he how are the tables related? There is very rarely^W^W practically never any reason to have loads of 1:1 relationships chopping up what could be a single record. My problem is that I need to use this queried information in a data entry order form. When I select from a drop down the company name, I would like the queried info - four fields of data - to appear as a reference. Then have the order details entered thereafter. Four fields or four tables? You can certainly use the AfterUpdate event of a combo or list box to adjust the .Recordset of the form, or move the form pointer to the correct record. But you have to make sure you have a sensible schema design first. Hope that helps Tim F |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Auto fill text boxes | emmy128 | Using Forms | 4 | September 29th, 2004 12:29 AM |
Setting up an auto fill cell | intheway | General Discussion | 4 | September 16th, 2004 07:50 PM |
Auto lookup fill in function - Need more help | Lam | General Discussion | 1 | August 13th, 2004 11:42 PM |
Auto fill criteria/questions on filling formulas down | JAnderson | General Discussion | 2 | July 19th, 2004 09:45 PM |
Drop List Valadation and Auto Fill | Aversin | General Discussion | 3 | July 15th, 2004 07:02 PM |