By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,687 Members | 2,046 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,687 IT Pros & Developers. It's quick & easy.

Autofill Data On Form

P: 6
Hey everyone, I'm kinda new to access, I have used it before but only to make real simple databases and now I am trying to organize and track more specific data and I am running into a few roadblocks. I have been reading solutions to this problem all over, but can't seem to get them to work for me.

This in Access 2002

I have two tables
1)Stores (Store Name, Store Number, Address, City, State, Zip, Phone)

2)Report Has many fields but the ones I am working on now are the same exact fields from the Stores table.

I have two forms
1)Stores - add/delete/edit store info

2)Report - agents fill out many fields for a report. What I want to happen is when a store name is selected from a combo box the text boxes with (Store Number, Address, City, State, Zip, Phone) are automatically filled in.

any help would be greatly appreciated

thanks
rob
Nov 8 '06 #1
Share this Question
Share on Google+
6 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hey everyone, I'm kinda new to access, I have used it before but only to make real simple databases and now I am trying to organize and track more specific data and I am running into a few roadblocks. I have been reading solutions to this problem all over, but can't seem to get them to work for me.

This in Access 2002

I have two tables
1)Stores (Store Name, Store Number, Address, City, State, Zip, Phone)

2)Report Has many fields but the ones I am working on now are the same exact fields from the Stores table.

I have two forms
1)Stores - add/delete/edit store info

2)Report - agents fill out many fields for a report. What I want to happen is when a store name is selected from a combo box the text boxes with (Store Number, Address, City, State, Zip, Phone) are automatically filled in.

any help would be greatly appreciated

thanks
rob
From what I understand you have created a separate table for the Report form using fields from other tables. Why didn't you just use a query joining all the tables. It would make life a lot easier.
Nov 8 '06 #2

P: 30
TH42, mmccarthy is right. Also, you don't have to make your REPORT table include fields that are in the STORES table, only the unique key that can link the two tables. The query will be able to show the other general info from the STORES. Your query may be of this format: StoreNumber from REPORTS: Address, City, State, Zip, Phone from STORES; all other fields from REPORTS that you want to update. You can opt to create a form from this query to enter update data for REPORTS.
Nov 8 '06 #3

P: 6
the data from the Stores table has to show up on the report form in a text box, the form has to be printed and sent out of the office.
Nov 8 '06 #4

P: 30
You can create report based on the query. The query has all the fields you want.
Nov 8 '06 #5

P: 6
thank you for the help i got it working :)
Nov 10 '06 #6

P: 3
How did you get it working?
Dec 1 '06 #7

Post your reply

Sign in to post your reply or Sign up for a free account.