Auto fill in Access form

Expand Post »

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!!

Last edited by ACayouette; May 5th, 2007 at 3:28 pm.

Similar Threads

Problems in Dynaform (Form Mail) URGENT HELP in PHP
How to open pdf documents from a Microsoft Access Form in MS Access and FileMaker Pro
Access in many form in Pascal and Delphi
Auto fill-in a field on the contact form in HTML and CSS
Auto fill textbox using ajax in php in PHP

ACayouette

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since May 2007

Permalink

May 13th, 2007

Re: Auto fill in Access form

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

DenisOxon

Reputation Points: 22

Solved Threads: 19

Posting Whiz

Offline

345 posts
since Jan 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS Access and FileMaker Pro Forum Timeline: Ms Access Data Entry

Next Thread in MS Access and FileMaker Pro Forum Timeline: compare images and retrive in ASP

DaniWeb Message

Cancel Changes

User Name
Password