473,325 Members | 2,308 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Autofill Data On Form

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
6 1997
MMcCarthy
14,534 Expert Mod 8TB
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
ebo2006
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
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
ebo2006
30
You can create report based on the query. The query has all the fields you want.
Nov 8 '06 #5
thank you for the help i got it working :)
Nov 10 '06 #6
lefr
3
How did you get it working?
Dec 1 '06 #7

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

Similar topics

0
by: Chris Sharman | last post by:
I'd like to design my pages to work cooperatively with browser autofill features. I've loked around, but can't find any good documentation on supported/unsupported field names...
1
by: shortbackandsides.no | last post by:
I'm having a lot of difficulty trying to persuade the Google toolbar autofill to act consistently, for example ======================= <html><head> <title>autofill test</title> </head><body>...
0
by: David Portabella | last post by:
Hello, I am a doing a survey about Autofill Web Forms softwares. Usually, they all collect information of the user once during the set-up phase (user knowledge base). Then, when the user...
0
by: Ray Holtz | last post by:
Is it possible to autofill a field based on what is entered into another field in a form? My form has an employee field, and department field. In an Items Table, I have fields FldEmployee, and...
1
by: Nick J | last post by:
Hi, I remember at one point access would autofill a text box when filtering by form, Like for example as I would type it would come up with matching records, similar to AutoComplete in Internet...
4
by: HTS | last post by:
I have written a membership database application (PHP + mySQL) and need to prevent autofill from filling in fields in a member record edit form. I know I can turn off autoFill in my browsers, I...
0
by: Randy | last post by:
Hi, I have some comboboxes that are created dynamically at run time based on user actions. I found a procedure on a message board to autofill the combobox text from the dataview that the...
2
coolgames
by: coolgames | last post by:
Where does internet explorer store autofill and website *form* data by the *form*, i mean in the address box where the websites popup. thank you
1
by: berlich | last post by:
Can I use visual basic.net to access the DOM in a web page so that I can autofill the text boxes? If so, can you point me in the right direction as to where to begin? I need to fill in a lengthy...
1
by: Nik Coughlin | last post by:
I'm doing some ajax validation on form fields, using the form change event. If I click Autofill in the Google Toolbar, fields are filled out but the change event is never fired, so the validation...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.