Autofill Data On Form

thinkhard42

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

msquared

Quote:

Originally Posted by thinkhard42

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.

ebo2006

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.

thinkhard42

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.

ebo2006

You can create report based on the query. The query has all the fields you want.

thinkhard42

thank you for the help i got it working :)

lefr

How did you get it working?

Autofill Data On Form

re: Autofill Data On Form

re: Autofill Data On Form

re: Autofill Data On Form

re: Autofill Data On Form

re: Autofill Data On Form

re: Autofill Data On Form

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about