•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 361,873 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,391 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser:
Views: 3468 | Replies: 1
 |
•
•
Join Date: May 2007
Location: Rochester, NY
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Auto fill in Access form I am done wracking my brain on this one, so if anyone has an answer I would be most grateful!
I am trying to format a form in Access where users could check off a box and have the home address (already enetered on another subform) auto-filled in the fields that follow. Conversely, if the box is unchecked, users can type the correct address into the fields that follow. This would be similar to the "checkout" function on some websites where you check the box to indicate that your shipping address is the same as the billing address that you had already entered. (Does this make sense?) I'm not terribly literate in VB, so any help is appreciated.
Thanks in advance!!
I am trying to format a form in Access where users could check off a box and have the home address (already enetered on another subform) auto-filled in the fields that follow. Conversely, if the box is unchecked, users can type the correct address into the fields that follow. This would be similar to the "checkout" function on some websites where you check the box to indicate that your shipping address is the same as the billing address that you had already entered. (Does this make sense?) I'm not terribly literate in VB, so any help is appreciated.
Thanks in advance!!
Last edited by ACayouette : May 5th, 2007 at 2:28 pm.
•
•
Join Date: Jan 2007
Location: Oxfordshire, England
Posts: 307
Reputation:
Rep Power: 2
Solved Threads: 14
Posting Whiz
It strikes me that you can do it two ways,
1) fill the address in as the form loads using vb to get info from previous form with the tick in box filled.
However if the user removes tick, then you have to code the removal of the address (more work)
2) Load the form with the address fields left blank.
The user either fills in a delivery adress or ticks the box to indicate use the previous address. Then when user leaves form you fill the delivery address in.
If you need more help, then ask some more or send me a message.
Denis
1) fill the address in as the form loads using vb to get info from previous form with the tick in box filled.
However if the user removes tick, then you have to code the removal of the address (more work)
2) Load the form with the address fields left blank.
The user either fills in a delivery adress or ticks the box to indicate use the previous address. Then when user leaves form you fill the delivery address in.
If you need more help, then ask some more or send me a message.
Denis
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
Linear Mode
- How to open pdf documents from a Microsoft Access Form (MS Access and FileMaker Pro)
- Access in many form (Pascal and Delphi)
- Auto fill-in a field on the contact form (HTML and CSS)
- Auto fill textbox using ajax in php (PHP)
- Defaulting values in MS Access subform (MS Access and FileMaker Pro)
- Pass Controls of Access-Form to sub in module (Visual Basic 4 / 5 / 6)
- Problems in Dynaform (Form Mail) URGENT HELP (PHP)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Ms Access Data Entry
- Next Thread: compare images and retrive in ASP
